第2个回答 2011-08-12
我也遇到并解决了这个问题,如需帮助请QQ我:280534302
示例
下例将 MyNwind 数据库中两个最初位于 C:\ 驱动器上的文件还原到 D:\ 驱动器上的新位置。为将数据库还原到当前时间,还应用两个事务日志。RESTORE FILELISTONLY 语句用来确定即将还原的数据库中文件的数量以及文件的逻辑和物理名称。
USE master
GO
-- First determine the number and names of the files in the backup.
RESTORE FILELISTONLY
FROM MyNwind_1
-- Restore the files for MyNwind.
RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH NORECOVERY,
MOVE 'MyNwind_data_1' TO 'D:\MyData\MyNwind_data_1.mdf',
MOVE 'MyNwind_data_2' TO 'D:\MyData\MyNwind_data_2.ndf'
GO
-- Apply the first transaction log backup.
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH NORECOVERY
GO
-- Apply the last transaction log backup.
RESTORE LOG MyNwind
FROM MyNwind_log2
WITH RECOVERY
GO本回答被网友采纳