Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL Server Microsoft
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
Posted 26-Dec-12 17:55pm
Comments
RDBurmon at 9-Jan-13 3:44am
   
Have you tried using SSME ?

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Please check this link, It may help you
 
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300#214941[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 420
1 CHill60 410
2 Sergey Alexandrovich Kryukov 384
3 PIEBALDconsult 245
4 BillWoodruff 243


Advertise | Privacy | Mobile
Web02 | 2.8.141015.1 | Last Updated 13 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100