question

HennessyWong-8921 avatar image
0 Votes"
HennessyWong-8921 asked CarrinWu-MSFT commented

Auto failover from seconday to primary fail

Hi,

I've created an always on group with 2 replicas, at first, the automatic failover from primary to secondary was fine. However, when I tried to switch over again from secondary, it didn't success. I had to do it manually to recover the service.
Is it one of the limitations with SQL standard edition? Thanks.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-ver15

Version: SQL standard edition 2019
Testing method: Stop SQL service to see if the connection breaks.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @HennessyWong-8921, we have not get a reply from you. Did any answers could help you? If there have any answers helped you, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @HennessyWong-8921,

Welcome to Microsoft Q&A!

Is it one of the limitations with SQL standard edition?

You can choose either automatic or manual failover in an Availability Group in SQL Server Standard or Enterprise edition. (Of course, you can only choose Automatic failover if you are in synchronous-commit mode, and that’s a good rule! ). Please refer to this blog to get more information.

The automatic failover period is 6 hours (default setting), so you couldn't failover again within 6 hours. Unless you set the maximum failures in the specified period to 2, and set the period (hours) to X(within your failures again time).
106908-1.png
106961-2.png


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



1.png (47.7 KiB)
2.png (22.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.