Posted by John P. Marshall on 10/01/17 11:42

Ryan,

I haven't done too much with mirroring yet but

> Do we also need a witness server, or can this be done (sensibly) with
> two SQL2005 servers ?

It is physically possible to do this with 2 servers (in fact it is
physically possible to do it on 1 server) but it really doesn't make sense.
The server can only be live if it has a quorum (2 out of 3) agree that it is
the live server. If the primary server is one machine and the second
machine contains the mirror server and the witness server both and the
second machine goes off-line you have effectively taken the primary server
off-line as well since it will no longer have a quorum.

HTH,
John

[Back to original message]