Post reply

availability group is not ready for automatic failover

  • December 19, 2014 at 12:27 am

    #314005

    I don't have experience in AVG , how to resolve and trouble shoot the availability group is not ready for automatic failover in sql2012

  • December 19, 2014 at 1:53 am

    #1765625

    Hi,

    Can you please be a little more descriptive.

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)

  • December 19, 2014 at 3:22 am

    #1765637

    we got alert

    Availability Group is not ready for automatic failover while it is configured to failover automatically in one of the server .

    iam not sure how to solve ?

  • December 19, 2014 at 5:05 am

    #1765665

    for automatic failover to be available you must have 2 replicas set for synchronous mode and they must both be set to automatic failover

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 26, 2014 at 1:20 am

    #1766443

    ramyours2003 (12/19/2014)

    we got alert

    Availability Group is not ready for automatic failover while it is configured to failover automatically in one of the server .

    iam not sure how to solve ?

    We can refer to the following article to troubleshoot this issue:-):

    Availability group is not ready for automatic failover:

    http://msdn.microsoft.com/en-us/library/hh213005(v=sql.110).aspx

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply