Click here to Skip to main content
12,942,930 members (60,140 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:

FROM DISK = 'C:\Insurity.BAK'
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'

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
RDBurmon 9-Jan-13 3:44am
Have you tried using SSME ?

1 solution

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

Solution 1

Please check this link, It may help you[^]

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 4,633
CHill60 2,880
Maciej Los 2,268
Jochen Arndt 1,900
ppolymorphe 1,755

Advertise | Privacy | Mobile
Web02 | 2.8.170518.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