July 24, 2007 at 12:51 am
Hi,
this is my error msg when i am trying to restore the differential backup i have received beloe error
Microsoft SQL-DMO(ODBC SQLState:42000)
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 terminating abnormally.
regards,
karthik kumar
July 24, 2007 at 2:51 am
Your full database restore should ahve been with norecovery clause i hope you have missed that and the database has already become online. You need to redo the restoration of full backup specifying norecovery clause and then restore the diff backup.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply