November 12, 2002 at 3:48 am
I have a Full backup of a database from a server which i wud like to restore on another server, which i have done successfully. What my problem is that i also want to restore some transaction logs which when restored gives me some problems...The error is as below:
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. msg: 4306
Can I solve this problem by getting a backup of the msater and the msdb databases to the server where i want to restore the Db.Wud that help.....And also cud someone tell me If I can find the queries fired in the transaction log and the records that were affected.
Thx in advance
Arvind
Arvind
November 12, 2002 at 4:32 am
When you di the full restore you let the database recover. Once the database has recovered no additional Differential or Transaction log backups can be restored. You will have to restore the Full backup to the Database in question only uing the WITH NORECOVER option if doing the QA or selecting the item to not recover additional restores in EM resotre database wizard. After you do the Full backup restore then you can apply the Transaction Log backup. Of course if you made changes to the Database or it's data they will be lost. Also, if you are settng this server up as a stanby server you can use the WITH STANDBY option in recovery (STANDBY allows a database to be brought up for read-only access between transaction log restores and can be used with either warm standby server situations or special recovery situations in which it is useful to inspect the database between log restores). Look at SQL BOL in the RESTORE topic for additional details.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply