locked
Converting (Mirror, Synchronized/Restoring...) --> to standalone database. RRS feed

  • Question

  • I Removed mirroring from the Principal database which left the "Mirror" in the state of (Restoring...). How can I convert the restoring mirror into a standlaone state where I can look at its tables,stored procs,  etc.


    TIA,
    barkingdog

    Saturday, September 19, 2009 3:33 AM

Answers

  • I found the answer. After the Principal has "died", run the following the Mirror:


    alter database <mydatabasename> set partner off
    restore database <mydatabasename> with recovery.

    Barkingdog

    Saturday, September 19, 2009 3:52 AM