locked
Reasons for Database mirrors fail-over RRS feed

  • Question

  • Hey all,

    I am new to Database mirroring,I want some baisc information about Database mirroring


    In A/P cluster If IsAlive check fails 5 times,Cluster services intiate fail-over to other node.

    Causes
    1.If Active node become very busy
    2.Active node not responded to heart beats(Heart beat fails)
    3.Storage connection issues

    Like above exaple .. Why mirror setup will intialte Fail-over reasons..

    Please some help me by providing reasons for Database mirroring fail-over.

    Thanks in advance

    Friday, September 21, 2012 9:43 AM

Answers

  • Automatic failvoer happen only in case of witness server is there.

    Witness server keep checking the both instances & failvoer once principle is not accessable.

    Refer Link : http://technet.microsoft.com/en-us/library/ms175191.aspx


    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    • Marked as answer by Maggie Luo Friday, September 28, 2012 4:07 PM
    Friday, September 21, 2012 9:40 PM

All replies