Thursday, March 31, 2011 11:07 PM
Hello and thanks in advance for your reply's.
We have 2 locations we want to mirror from/to and provide for complete disaster recovery. Let's call Corp. location A and the Distribution Center location B. I would like to implement mirroring with high-safety as follows. This way if either location goes down, automatic fail over will occur to the other location. It is possible in a mirrored scenario for both the Principal and Witness to fail and go down simultaneously.
Server 1: A(Principal)
Server 2: A(Witness)
Server 3: B(Mirror)
Server 4: B(Witness)
Is this possible and what special configurations must occur to make this work.
Friday, April 01, 2011 7:38 AM
AFAIK you cant set up multiple witnesses for single mirroring session. So, you could either 'secure' witness by setting it up on cluster environment, or you could try setting up witness monitoring where you would check for the witness availability and issuing failover in proper scenario.
So, if principial and witness go down at the same time, dont think you have automatic failover option out of the box.
- Proposed As Answer by SleepingSpid Thursday, April 21, 2011 5:38 AM
Friday, April 01, 2011 12:25 PMNo, you can only have 1 witness. Should you be unable to achieve a quorum between the principal and the mirror, the principal and the witness, or the mirror and the witness your principal will be suspended.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
Friday, April 01, 2011 1:03 PMNo - only 1 witness, 1 principal and also only 1 mirror.
Sunday, April 17, 2011 5:01 AMNo not possible you must have only one witness.