January 30, 2009 at 10:10 am
We had a sql server 2000 instance outage and restart while a large database was in the middle of a restore. The database came back up with the status of 'restoring'. However, the actual restore process was killed and not restarted. How do I start another restore process when the database is still in single user mode with a restore status?
Thanks, Jen
January 30, 2009 at 1:15 pm
No sure if this is the best approach, but we took the database offline, restarted the instance and then were able to start a new restore process. Any better ideas?
February 3, 2009 at 12:24 pm
There isn't anyway to restart the restore once it abends. What you did is appropriate. You probably could've right-clicked on the database and deleted as well. Not sure why you restarted the instance but it obviously worked for you.
-- You can't be late until you show up.
February 3, 2009 at 1:15 pm
did you try just kicking off another restore, I would expect that to work.
---------------------------------------------------------------------
February 3, 2009 at 1:22 pm
We did just try another restore but we'd get the message that the database was in single user mode due to an in-progress recovery! So you are hooped. It is the oddest thing to delete a production database, but in the end that's what we needed to do to be able to restart the failed restore.
February 3, 2009 at 1:32 pm
There is a restart option for RESTORE. Not sure if it will apply for you, but you can try it.
http://technet.microsoft.com/en-us/library/aa238405(SQL.80).aspx
February 3, 2009 at 1:42 pm
Jen Hutchinson (2/3/2009)
We did just try another restore but we'd get the message that the database was in single user mode due to an in-progress recovery! So you are hooped. It is the oddest thing to delete a production database, but in the end that's what we needed to do to be able to restart the failed restore.
unusual. I'm guessing the original outage was not a clean stop of SQL? Guessing the clean restart cleared it.
lot of guessing going on here. 🙂
---------------------------------------------------------------------
February 3, 2009 at 1:48 pm
Yeah, it was a bad bump! Thanks for the reference for restarting a recovery and everyones help. I'll check if our backup tool has a restart option and test this out.
Jen
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply