Home Forums SQL Server 2008 SQL Server 2008 High Availability Where to locate the Witness server when using Mirroring for DR RE: Where to locate the Witness server when using Mirroring for DR

  • May 12, 2013 at 3:37 am

    #1614435

    Russell101 (5/12/2013)

    Thanks for the info Perry.

    So in the event of a power outage at the primary site where the secondary server will lose communication with both the primay and witness server will it automatically failover?

    No. "If the mirror server is disconnected from the witness and also from the principal server, automatic failover is not possible, regardless of the state of the principal server." http://msdn.microsoft.com/en-us/library/ms175191%28v=sql.105%29.aspx

    You should make a good DR plan for different type of outage, and now eg. when perform a manual failover in case of failure.