请检查此链接，它可能对您有所帮助



http://www.sqlteam.com/forums/ topic.asp？TOPIC_ID = 54300＃214941 [ ^ ]

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

Please check this link, It may help you

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300#214941[^]