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

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

more ▼

asked May 07, 2010 at 12:08 AM in Default

aashish77 gravatar image

15 2 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest

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

more ▼

answered May 07, 2010 at 04:44 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 07, 2010 at 12:08 AM

Seen: 969 times

Last Updated: May 07, 2010 at 04:40 AM