October 28, 2004 at 3:40 am
Dear All
I am trying to restore a Differential Backup but the server is not allowing me to restore it is giving the error :-
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. RESTORE DATABASE is terminatin abnormally.
Any help will be greatly appreciated.
Regds
Dharmendra
Thanks & Regards
Dharmendra S Mudaliar
( OEM India RSA )
Hello - +91 40 66934555 x 34555
Mobile - 9885408049 | IM - v-dharmu@microsoft.com
October 28, 2004 at 4:10 pm
You have to restore a full database backup before restoring a differential.
Restore a full database backup using WITH NORECOVERY i.e.
RESTORE DATABASE mydb FROM mydbbackup_bak WITH NORECOVERY
Then restore the differntial backup using WITH RECOVERY i.e.
RESTORE DATABASE mydb FROM mydbbackup_diff WITH RECOVERY
This assumes that your full backup and differential backup on on different backup devices. See "Differential Database Backups" in Books OnLine.
Greg
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply