locked
How can do manual failover in mirroring?? RRS feed

  • Question

  • How can we do manual failover in mirroring??i know that mirroring is a automatic failover..

    Sivamanikanta. P

    Friday, May 4, 2012 1:15 PM

Answers

  • Two ways -

    1. Principal available - Run below command on principal 

      ALTER DATABASE dbName SET PARTNER FAILOVER

    2. Principal not available  - Run below command on mirroring

    ALTER DATABASE dbName SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS


    http://uk.linkedin.com/in/ramjaddu

    • Proposed as answer by amber zhang Monday, May 7, 2012 2:12 AM
    • Marked as answer by amber zhang Friday, May 11, 2012 8:48 AM
    Friday, May 4, 2012 4:43 PM

All replies

  • connect to the Principal Server and initiate the following command:

    USE [master];
    GO
    ALTER DATABASE [TestDB] SET PARTNER FAILOVER;
    GO
    For more info, check the following post from Books  Online : http://msdn.microsoft.com/en-us/library/ms179481.aspx

    SKG: Please Marked as Answered, if it resolves your issue. (b: http://sudeeptaganguly.wordpress.com)


    Friday, May 4, 2012 1:30 PM
  • Hello,

    Check this article 

    Manually Failover a database mirroring session

    http://msdn.microsoft.com/en-us/library/ms186348.aspx


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    Friday, May 4, 2012 1:49 PM
  • Two ways -

    1. Principal available - Run below command on principal 

      ALTER DATABASE dbName SET PARTNER FAILOVER

    2. Principal not available  - Run below command on mirroring

    ALTER DATABASE dbName SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS


    http://uk.linkedin.com/in/ramjaddu

    • Proposed as answer by amber zhang Monday, May 7, 2012 2:12 AM
    • Marked as answer by amber zhang Friday, May 11, 2012 8:48 AM
    Friday, May 4, 2012 4:43 PM