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 |
|
rajuussvk
Starting Member
1 Post |
 Posted - 2007-03-29 : 07:27:26
|
| I have taken full back in the morning and i have diffrential backups after that. I restored full back without any problem but I am getting problem when restoring diffrential backup. I am getting the following errorThe preceding restore operation didnot specify with norecovery or with standby. Restart the restore sequence with norecovery or with standby for all but the final step.What i ahve to do now? Pls help me. thanks in advanceRaju |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-03-29 : 07:39:50
|
| The error message is right on the money! You need to specify WITH NORECOVERY for all but the final restore (i.e. your Full backup and all but your final differential backup).Mark |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-02 : 04:09:47
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example |
|
|
|
|
|
|
Restore Backup