DR Scenario RRS feed

  • Question

  • For High Protection mode (2servers, no witness, FULL safety), in the event of a catastrophic failure of the principal, can a remote (but well connected) mirror be forced to assume the principal role?  The MS manual "Database Mirroring in SQL Server 2005" on p2 says the failover type for HP mode is manual only (as opposed to forced).  Elsewhere it seems to seems suggest otherwise but there is no clear and unambiguous discussion describing the exact procedure.


    Can anyone clarify this matter?  Thanks,



    Monday, August 13, 2007 6:46 PM

All replies

  • Since posting this question I have found in the May 2007 SQL 2005 Books On Line a clear statement that the mirror server in the above scenario can be forced to the principal mode.

    Monday, August 13, 2007 9:07 PM
  • Bud,

           In high protection mode the failover is Manual. As no witness server is available automatic failover is ruled out. So  the manual failover is done as follows,


    1.either clicking the Failover button in the Database Properties/Mirroring dialog in SSMS or


    once it is done the mirror server will become the principal server.

    refer, http://sql-articles.com/articles/dbmrr.htm

    Tuesday, August 14, 2007 1:00 AM
  • Bud


    Just to add. Your statement stated that you can FORCE a failover. In High Protection you dont need to force a failover because the data is in sync. You only force a failover in High Performance mode using the


    because the data may not be in sync and you are accepting the loss.

    Tuesday, August 14, 2007 8:13 AM