MSSQL 从备份文件还原数据库脚本
RESTORE DATABASE Welding
FROM DISK = 'E:\项目\sql2000-110614.bak'
with replace,
MOVE 'Welding' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\Welding.mdf',
MOVE 'Welding_log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\Welding_log.ldf'
FROM DISK = 'E:\项目\sql2000-110614.bak'
with replace,
MOVE 'Welding' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\Welding.mdf',
MOVE 'Welding_log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\Welding_log.ldf'
