Click here to Skip to main content
12,951,619 members (56,111 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
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 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
Top Experts
Last 24hrsThis month
OriginalGriff 6,084
CHill60 3,480
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,830


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 13 Jan 2013
Copyright © CodeProject, 1999-2017
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