What is a witness server used for? Why use it?
+5
A:
The witness is a third instance of a server that acts as an intermediary between the principal and the mirror to determine when to failover.
See http://technet.microsoft.com/en-us/library/ms175191.aspx
Peter Mourfield
2010-05-06 20:53:59
+1: A witness is necessary for hot failover.
OMG Ponies
2010-05-06 21:02:43
+5
A:
The witness is the one that brings the third vote into the mix in order to create a quorum. Principal and mirror each has one vote, so they can tie 1:1 and no decision can be made. With a witness there can be a quorum established 2:1 or 1:2 (or o:2 if the principal is unreachable) and therefore a decision can reached who should be the new principal. The net effect is that witnesses make automatic failover possible, because the mirror together with the witness can form a majority and decide to fail over if contact with the principal is lost.
Remus Rusanu
2010-05-06 21:27:26
A:
The witness is a third instance of a server that acts as an intermediary between the principal and the mirror to determine when to failover.
See http://technet.microsoft.com/en-us/library/ms175191.aspx
rammsito
2010-05-07 05:15:45