Post reply

Database Stuck in "Restoring .." Mode?

  • December 18, 2012 at 1:20 am

    #272202

    Hello,

    Anyone know how to set the database state such that it is NOT showing "Restoring .." in SSMS?

    I had started scripting a sequence of RESTORE's, but closed SSMS and when I tried to continue testing later I was notified that the database was being used. No doubt due to the database being in "Restoring" mode.

    Any help appreciated.

    Regards

    Steve

  • December 18, 2012 at 1:59 am

    #1569405

    If the restore completed but was run WITH NORECOVERY then run RESTORE DATABASE <db name> WITH RECOVERY

    If you aborted the restore part way through, drop the DB and run the restore again (or run a RESTORE with the restart option)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 18, 2012 at 2:25 am

    #1569417

    Had to drop the DB, but the restore then worked fine.

    Thanks. 🙂

  • December 18, 2012 at 2:35 am

    #1569420

    Hmmmm ... of course, now that I've dropped and restored the DB I can see that for some reason my log file has been renamed.

    Not sure why this should happen.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply