November 20, 2019 at 7:16 pm
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
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
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?
November 21, 2019 at 8:39 am
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply