USE master
restore database 数据名 from disk='c:=\test.bak' with REPLACE或:还原修改数据库路径:
RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH NORECOVERY,
MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf',
MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf'
restore database 数据名 from disk='c:=\test.bak' with REPLACE或:还原修改数据库路径:
RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH NORECOVERY,
MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf',
MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf'
restore database 数据名 from disk='c:=\test.bak' with REPLACE或:还原修改数据库路径:
RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH NORECOVERY,
MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf',
MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf'
restore database 数据库名 from disk='d:\sys\data\有要恢复的数据文件' with REPLACE或:还原修改数据库路径:
RESTORE DATABASE 数据库名
FROM disk='d:\sys\data\有要恢复的数据文件'
WITH MOVE 'test' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\test.mdf',
MOVE 'test_log' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\'test_log.ldf'
逻辑文件名为:test600 test600_log
原始文件(.mdf与.ldf文件)存放在:c:\test600.mdf c:\test600_log.ldf
现在如果要将此备份文件恢复到testMove数据库,而且将它的原始文件放在d:\你就可以用下列命令来实现:restore database testMove from disk='c:\test600.bak'
with
move 'test600' to 'd:\testMove.mdf',
move 'test600_log' to 'd:\testMove_log.ldf'