I have a Restore related question from one of my DBA Friends mentioned bellow
Hi, I tried restoring DB with below query
RESTORE DATABASE sirwar
FROM DISK = 'F:\15.02\15.02.12 backup'
MOVE 'LogicalDatafileName' TO 'f:\sirwar.mdf',
MOVE 'LogicalLogfilename' TO 'f:\sirwar.ldf'
but this came with an error like this..........
Msg 3234, Level 16, State 2, Line 1 < '
Logical file 'LogicalDatafileName' is not part of database 'sirwar'. Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Solutions mentioned bellow:
1) sp_helpdb on the source database. It's the first column in the
second result set, just copy and paste into the single quotes.
2) RESTIRE FILELISTONLY on the back-up file. Again, it's the first
Posted by: MR. JOYDEEP DAS