Post reply

AOAG did not failover to other node

  • November 20, 2019 at 7:16 pm

    #3699328

    We had a crash on primary node, created memory dump. But AOAG group did not fail over to secondary node.

    So, when we encounter memory dump on primary, does AOAG will not fail over? are there any scenarios where AOAG fail over will not work?

  • November 20, 2019 at 8:03 pm

    #3699346

    Is anything showing in the cluster or SQL server logs?

    Does your cluster only consist of the two servers or do you have a third item such as a File Share Witness?

    Is the Availability Group set for automatic failover?

  • November 21, 2019 at 12:24 am

    #3699408

    No information in the logs other than memory dump.

    We had failover as Manual. But if the primary is not healthy, will it not failover to secondary at all with Manual failover setting?

     

    • This reply was modified 5 years ago by  IMary.

  • November 21, 2019 at 8:39 am

    #3699483

    No, that's the point. If you want it to fail over automatically it needs to be set to automatic failover.

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

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