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 |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2003-07-28 : 00:57:15
|
| I have scheduled total 3 backups as follows1. Full backup at 03:00 AM every day with overwirte existing file option.2. Full backup at 13:30 PM every day with overwrite existing file option.3. Differential backup at every hour with overwrite existing file option.Now if i try to restore database with latest full backup and differentiol back up, full backup gets restored successfully, but when i try to restore differential backup it shows me following error."The preceding restore operation didnt specify WITH NONCOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH STANDBY for all but the final step.Backup or restore operation terminating abnormally."Is it due to i set overwrite option for differential back up? should it be append?What can be the reason?Thanc in advance.---------------------------Sandesh - The Messanger |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2003-07-28 : 01:20:50
|
| Are you spceifying With NORECOVERY for the restore of full backup? If you don't specify it SQL will understand that database must be recovered and will not allow you to restore additional bdiferential or tran log.Sérgio Monteiro |
 |
|
|
|
|
|
Restoring differential backup