locked
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,

     

    Bud

    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

    2.ALTER DATABASE DBNAME SET PARTNER FAILOVER

    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

    ALTER DATABASE <database> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

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

    Tuesday, August 14, 2007 8:13 AM