Problems in Restoring Log backupsin a SQl Server 2000 DB with Different Name

Question

Am New to Sql server 2000 DBA.

I have a database (myDb1) with recovery mode=Full. Took the full DB backup and Transaction log backup.

Need to restore them on another server where the database is created using a different name(Application Requirement). I am able to create the DB with the different name sucessfully.

Restore Database (myDB1)  
from Disk = 'F:\temp\myDb1_DB_bkup_Full_07.05.2010.bak'  
with move 'myDB1'  
to 'E:\Program Files (x86)\Microsoft SQL Server\MSSQL\data\myDB1new.mdf',  
move 'myDB1_log'  
to 'E:\Program Files (x86)\Microsoft SQL Server\MSSQL\data\myDB1new_log.mdf'

Now when I try to apply the Tlogs of myDB1 I get the following error

Restore log myDB1new from Disk ='F:\temp\myDB1_log_bkup_1_07.05.2010'

Server: Msg 4306, Level 16, State 1, Line 1
The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
Server: Msg 3013, Level 16, State 1, Line 1 RESTORE LOG is terminating abnormally.

Please Suggest

Answer 1

0

You have done a restore and the database is online, it is not able to take more log restores as it is expecting normal system use to update data. If you want to restore further log files then, as the error message suggests, try adding WITH NORECOVERY or WITH STANDBY to the first restore command. I would suggest you want WITH NORECOVERY. Once you have finished restoring logfiles leave it out of the last restore command and the database will be online

answered May 07 '10 at 04:44 AM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104

(comments are locked)

Problems in Restoring Log backupsin a SQl Server 2000 DB with Different Name

Follow this question

Related Questions