问题描述
我有一个名为insurity.bak的数据库的备份，该数据库取自一台Sql server 2008 r2机器。我想在另一台也有sql server 2008 r2的机器上恢复它。
当我做RESTORE FILELISTONLY我得到了这个输出。
孵化器:: C：\程序文件（x86）\ Microsoft Microsoft SQL Server \ MSSQL.1 \ MSSQL \DATA \Insurity.mdf
Incubator_log :: C：\Program Files（x86）\ Microsoft SQL Server \ MSSQL.1 \ MSSQL \DATA\Insurity.ldf。
I使用thid查询进行恢复：
RESTORE DATABASE Business
来自DISK =''C：\Insurity.BAK''
WITH REPLACE，
移动''Insurity''到''C：\Program Files \ Microsoft SQL Server \ MSSQL10_50.MSSQLSERVER \ MSSQL \ DATA \ Business.MDF''，
MOVE''Insurity''TO''C：\ Program Files \ Microsoft SQL Server \ MSSQL10_50.MSSQLSERVER \ MSSQL \DATA\Business_Log.LDF ''
GO
我收到错误消息msg：
消息3234，Leve l 16，状态2，服务器INFCH05324，第1行
逻辑文件''Insurity''不是数据库''Business'的一部分。使用RESTORE FILELIST
仅列出逻辑文件名。
消息3013，级别16，状态1，服务器INFCH05324，行1
RESTORE DATABASE正在异常终止。
请帮我解决这个问题。任何帮助将不胜感激。
提前致谢
I have a backup of a database named insurity.bak taken from one Sql server 2008 r2 machine. I want to restore it on another machine which also has sql server 2008 r2.
when i did RESTORE FILELISTONLY i got this output.
Incubator:: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Insurity.mdf
Incubator_log:: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Insurity.ldf.
I did the restore using thid query:
RESTORE DATABASE Business
FROM DISK = ''C:\Insurity.BAK''
WITH REPLACE,
MOVE ''Insurity'' TO ''C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Business.MDF'',
MOVE ''Insurity'' TO ''C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Business_Log.LDF''
GO
I get thids error msg:
Msg 3234, Level 16, State 2, Server INFCH05324, Line 1
Logical file ''Insurity'' is not part of database ''Business''. Use RESTORE FILELIST
ONLY to list the logical file names.
Msg 3013, Level 16, State 1, Server INFCH05324, Line 1
RESTORE DATABASE is terminating abnormally.
pls help me out with this issue. Any help will be greatly appreciated.
Thanks in advance
这篇关于恢复从1台服务器获取的数据库备份（.bak）文件并将其还原到另一台服务器上。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！