Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mohit_sharan
Starting Member
22 Posts |
 Posted - 2005-08-08 : 03:35:19
|
| Hi All, I am using SQL Server 2000 and my recovery model is Bulk Loged. When I am doing my restore of transaction logRESTORE log PUBS from disk='Z:\Backup\PUBS_Log_Backup_20058836.bak' WITH RESTRICTED_USER ,NORECOVERY I am getting the below error...Server: Msg 4306, Level 16, State 1, Line 1The 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 1RESTORE LOG is terminating abnormally.Can any one let me know where is the problem...Thanks in advance. |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-08-08 : 04:47:32
|
| The WITH NORECOVERY option is required by all but the final restore statement when you're restoring a database backup and multiple logs. Start the sequence again remembering to specify WITH NORECOVERY for each restore save the last one.Mark |
 |
|
|
chetancool
Starting Member
34 Posts |
Posted - 2005-08-08 : 06:37:47
|
| U have to specify no-recovery for all the step (if u have to restore multiple transaction log backup) but only for the last step, u will specify with recovery option.This option tell the server that this is the last file which u want to restore.Keep SmilingChetan |
|
|
|
|
|
|
Restoring Log