Database Mirroring - Question

  • If witness goes down will the primary also go down? I do not have three instances to test so i request someone who has already tested this before to give me some advice.Thanks

  • No, but you will not have auto-failover capabilities until the witness comes back.

    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
  • I could still do a manual failover right?

  • sqldba_icon (12/20/2010)


    I could still do a manual failover right?

    Yes you can do manual failover.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Thanks

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

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