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.
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'
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, 2010 at 04:44 AM