May 24, 2009 at 4:55 pm
I had two servers between which log shipping had been established for testing purposes. The primary server has been taken offline. But on the second server, the destination DB is still in "recovering" mode. How can I take it out of recovering mode so that I can delete it?
May 24, 2009 at 5:22 pm
RESTORE DATABASE ... WITH RECOVERY;
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
May 24, 2009 at 5:41 pm
That what I thought and tried before posting this question:
Msg 4319, Level 16, State 3, Line 1
A previous restore operation was interrupted and did not complete processing on file 'LogTest_Log'. Either restore the backup set that was interrupted or restart the restore sequence.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
May 24, 2009 at 7:45 pm
Well, the message tells you exactly what you need to do. You need to restart the restore operation for the last log file that was interrupted.
But, if all you want to do is delete the database then detach the database and manually delete the files. That will accomplish the same thing.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
May 27, 2009 at 9:38 am
Well you can drop the database if its for testing purpose.
To Restore:-
Restore Database with recovery
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply