1.首先使用restore Filelistonly 显示bak 文件中包含的数据库和日志文件列表
RESTORE FILELISTONLY FROM DISK = 'D:\FMSDB\AuthoringTool\FMSGuo.bak'
信息如下
LogicalName PhysialName
SystemCatelogFile
SystemCatelogFile_1
SystemCatelogFile2
SystemLogFile
2.使用MOVE TO
1)首先删除掉你刚才创建的DB,用来还原.bak
2) 使用如下语句(MOVE 后面的文件对应上面的LogicalName)
RESTORE DATABASE FMSAuthoringDB
FROM DISK = 'D:\FMSDB\AuthoringTool\FMSGuo.bak'
WITH MOVE 'SystemCatalogFile' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.WS_HGO\MSSQL\DATA/FMSAuthoringDB_data.mdf',
MOVE 'SystemLogFile' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.WS_HGO\MSSQL\DATA/FMSAuthoringDB_data.ldf',
MOVE 'SystemCatalogFile_1' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.WS_HGO\MSSQL\DATA/FMSAuthoringDB_data_1.ldf'
MOVE 'SystemCatalogFile2' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.WS_HGO\MSSQL\DATA/FMSAuthoringDB_data_2.ldf',
NOUNLOAD, REPLACE