Post reply

db mirroring

  • January 4, 2011 at 2:14 am

    #245007

    Hi All,

    It is necessary to quorm(estblishing device connection) between the witness server to primary and mirror servers..

    what happened if you are not configuring the witness server in db mirroring..

    Thanks

  • January 4, 2011 at 2:35 am

    #1268817

    No witness means no automatic failover. You can still manually fail over to the mirror, but it won't happen automatically if the principal goes down.

    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

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

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