none
Principal server crashed RRS feed

  • Dotaz

  • Good Morning Experts,

    Principal server crashed and automatic failover started but mirror is not coming up online. How to deal with this situation?


    Kiran

    pátek 5. července 2019 15:46

Všechny reakce

  • You may need to do a force failover. 

    ALTER DATABASE [MyDatabaseName]
    SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    pátek 5. července 2019 16:26
  • But the server has not come up online. Both principal and mirror are down.

    Kiran

    neděle 7. července 2019 13:27
  • Hi kiran,

    The answer related to the mode that mirroring is configured. 

    Safety FULL with Witness :

    The mirror server will form a quorum with witness and will initiate an automatic failover.

    Safety FULL without Witness :

    ALTER DATABASE dbname SET PARTNER OFF
    RESTORE DATABASE dbname WITH RECOVERY

    Safety OFF :

    ALTER DATABASE dbname SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    Please refer to  How can I bring mirror database online after principal server is down ?

    Hope this could help you.

    Best regards,
    Cathy Ji

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    pondělí 8. července 2019 7:51
  • Hi Cathy,

    Its just not the database , the whole mirror server is down.


    Kiran

    pondělí 8. července 2019 8:30
  • Hi Kiran,

    So, you issue is that the SQL server service can't be started? If so, please share us error log for analysis.  If i misunderstood, please let me known.

    Best regards,

    Cathy ji


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    pondělí 8. července 2019 10:06