Post reply

AlwaysOn Secondary Replica - Resolving state

  • May 21, 2013 at 2:34 am

    #273005

    Hi all

    I have an AlwaysOn Availability group configured between 2 nodes (Synchronous)

    Automatic failover was working fine until recently

    I can failover between the nodes manually but automatic failover doesn't seem to be working. In my earlier test, I would shut down the SQL Service on the primary and within seconds, the secondary replica would take over. Recently I have performed the same test and the secondary replica enters the resolving state and the DB in unavailable.

    I have tried everything here: http://support.microsoft.com/kb/2833707

    The only change I made was changing the availability mode from Synchronous to Asynchronous - Could that be the cause?

    Thanks

  • May 21, 2013 at 7:53 am

    #1617019

    I forgot to mention that after changing in to Async, I changed it back to Synchronous - Still same issue, automatic failover not working

    Thanks

  • February 17, 2015 at 11:52 am

    #1778149

    was this issue resolved?

    Prakash B

  • February 18, 2015 at 12:07 am

    #1778255

    Prakash.Bhojegowda (2/17/2015)

    was this issue resolved?

    Yes

    It had to do with a setting in the cluster that determines how many failovers can occur within a defined time period.

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

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