none
Database Mirroring failover RRS feed

  • Question

  • Hi,

    I have configured mirroring, server A and server B, suppose if server A down, what are the action we need to tak bring up principal server.

    Thanks in advance


    Shashikala

    Sunday, June 15, 2014 10:39 AM

Answers

  • Thank you. If we configured as safety with automatic failover. In this case mirror server will come online automaticaly if pricipl server down? or do we need to follow above steps to come nline.

    Thanks


    Shashikala

    If witness is configured and principal is down and witness is able to form quorum with mirror automatic failover will happen. If quorum is not being formed anyhow for some reason no automatic failover will happen and then mnual failover will be required.

    See various scenarios mentioned in below link (Database Mirroring Availability Scenarios)

    Database mirroring in SQL server



    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    • Marked as answer by bhat BK Sunday, June 15, 2014 12:40 PM
    Sunday, June 15, 2014 12:17 PM

All replies

  • Hi,

    You need to run below command on Mirror server to Make it online. Run below command on Mirror database

    ALTER DATABASE DB_NAME SET PARTNER OFF
    GO
    RESTORE DATABASE DB_NAME WITH RECOVERY

    Above command will break mirroring and bring Mirror database online

    More details In this Link


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Sunday, June 15, 2014 11:01 AM
  • Thank you. If we configured as safety with automatic failover. In this case mirror server will come online automaticaly if pricipl server down? or do we need to follow above steps to come nline.

    Thanks


    Shashikala

    Sunday, June 15, 2014 11:26 AM
  • Thank you. If we configured as safety with automatic failover. In this case mirror server will come online automaticaly if pricipl server down? or do we need to follow above steps to come nline.

    Thanks


    Shashikala

    If witness is configured and principal is down and witness is able to form quorum with mirror automatic failover will happen. If quorum is not being formed anyhow for some reason no automatic failover will happen and then mnual failover will be required.

    See various scenarios mentioned in below link (Database Mirroring Availability Scenarios)

    Database mirroring in SQL server



    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    • Marked as answer by bhat BK Sunday, June 15, 2014 12:40 PM
    Sunday, June 15, 2014 12:17 PM