Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mirror and witness
Message
From
05/02/2009 09:30:50
 
 
To
04/02/2009 08:44:08
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01379184
Message ID:
01379454
Views:
17
This message has been marked as the solution to the initial question of the thread.
I have found an answer myself. I am posting it in case anyone is interested.

http://technet.microsoft.com/en-us/library/cc917680.aspx



>If you have mirroring set up, with the witness at the same location as the Mirror server (not the primary), and that site losses its external connectivity, the mirror and witness will both lose connection with the primary SQL server, and the mirror will assume primary status, even though the primary SQL Server is still online to the rest of the world (or its target consumers).
>
>If the witness is set up with the primary SQL Server, and both are taken out (by fire, etc.), then the witness will not automatically rollover.
>
>It would seem that a 3rd site is needed to perform this reasonably.
>
>I would appreciate any input on this matter from anyone who is or has used mirroring in a production environment.
>
>Your input is greatly appreciated.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Previous
Reply
Map
View

Click here to load this message in the networking platform