Post reply

Both principal and mirror down

  • November 10, 2015 at 5:17 am

    #322146

    Respected Experts,

    In mirroring, what will happen if both principal and mirror servers go down, and only mirroring server comes up?What will be the status of mirroring?

  • November 10, 2015 at 6:27 am

    #1838816

    Depends on whether there's a witness. Is there?

    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 10, 2015 at 7:00 am

    #1838839

    Witness is not there

  • November 18, 2015 at 7:44 am

    #1840676

    When the witness does not exist and the primary goes down, I believe mirroring will be broken and you have to manually make the mirror DB the primary.

    I know when we DR tested our mirroring without a witness, we had to manually make the mirror the primary. But the primary server wasn't actually down so much as stopped. Then we were able to switch back to the primary (again manually) when we stopped the mirroring on the secondary server. So mirroring wasn't officially broken in our case. It was still a manual failover, though.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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