Instance restart in middle of restore leaves database with restore status and no restore process

  • 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

  • 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?

  • 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.

  • did you try just kicking off another restore, I would expect that to work.

    ---------------------------------------------------------------------

  • 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.

  • 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

  • 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. 🙂

    ---------------------------------------------------------------------

  • 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