SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
362 questions
:)
SQL Always On did not failover
Salves
501
Reputation points
Hi,
we did several failover tests with SQL Always On, restarting the server and disconnecting the network card everything worked perfectly.
But in a specific test we noticed that the failover did not occur and it shows the server status as (Resolving). Identical to the case when synchronization is asynchronous, in which after manual failover it returns to its normal state.
This test was simply shutting down the SQL service and the status showed (Resolving).
After turning on SQL or restarting the server everything goes back to normal.
The server has a network for management access and a network for replication that we define in the endpoint configuration the TCP URL.
What could be happening?
Thank you.
{count} votes
-
Erland Sommarskog 102.9K Reputation points2020-10-06T21:57:36.013+00:00 Shanky knows this better, and I am sure he will reply when he sees this thread. I know, because I eavesdropped on another thread where explained this. I will just give you a quick answer here and now: you need to change the failure-condition for the AG to 1 (default is 3) for an SQL Server restart causing a failover.
-
Salves 501 Reputation points
2020-10-06T22:27:30.827+00:00 Hi,
when we restart the service it fails over correctly as expected.
The problem is when we turn off the SQL service.
I have three nodes with quorum file share.
Thank you.
-
Salves 501 Reputation points
2020-10-07T00:47:52.74+00:00 @Shashank Singh , help-me.
Sign in to comment
Accepted answer
-
Salves 501 Reputation points
2020-10-07T03:39:53.067+00:00 -
Shashank Singh 6,246 Reputation points2020-10-07T05:07:50.453+00:00 @Salves Did you find out the solution or you still need a help ? . The above blog seems to have details and solution about the issue you are facing. BTW you tagged wrong Shashank :)
-
CathyJi-MSFT 21,106 Reputation points Microsoft Vendor2020-10-07T06:08:22.617+00:00 Hi @Salves ,
It seems you have found the solution. If that, please mark your solution as answer. This can be beneficial to other community members reading the thread.
Best regards,
Cathy -
Salves 501 Reputation points
2020-10-08T04:28:11.767+00:00 I tried to tag you three times and I couldn't. It may be that his name is correct, but he did not recognize his full nickname.
Sign in to comment -