Post reply

Database is in Restoring mode

  • November 12, 2009 at 3:52 pm

    #212282

    This is a database that used to be a mirror in a mirroring session for quite some time.

    I removed mirroring by running this command on the principal:

    ALTER DATABASE database_name SET PARTNER OFF

    GO

    However mirror databsae shows "(Restoring...)" in SSMS. How to bring it to normal operational mode ? I tried to check ALTER DATABASE in B.O.L. but could not find anything for this.

    Thanks

  • November 12, 2009 at 4:13 pm

    #1078640

    Try RESTORE DATABASE <DB Name> WITH RECOVERY

    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

  • November 12, 2009 at 6:26 pm

    #1078667

    Note that it's a good habit to do all your restores with NORECOVERY and then use Gail's statement to complete the restore. That way if you find another log to restore, you aren't stuck starting from scratch.

    Mirroring is in this place, restoring log transactions and the WITH RECOVERY brings it out of restoring mode.

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

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