question

JohnJY-4666 avatar image
0 Votes"
JohnJY-4666 asked AmeliaGu-msft commented

SQL AG shown in WFCS

Hi all,

We have two nodes Node1 and Node2 which resides at a different site. There is SQL AG configured.

When I check it AG role in Failover Cluster Manager, "allow it failback immediately" is checked.

What's the reason behind this? Do settings get from SQL or manually check it in FCM?

Thank you!

sql-server-generalwindows-server-clustering
· 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 JohnJY-4666,
How are things going on? Do the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi JohnJY-4666,

According to the new alwayson availability group I created, it seems to be automatically selected by default in Failover cluster manager.
Allow failback immediately specify the clustered role will automatically fail back to the most preferred owner when the preferred owner is active. When a node becomes inactive for any reason, the Cluster service fails over any groups hosted by the node. When the node becomes active again, the Cluster service can fail back the groups originally hosted by the node. You can set failback to occur during a specific time period. It is important to set the failback time because you may not want failback to occur during hours of peak usage.

Best Regards,
Amelia


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.


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.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hello @JohnJY-4666,

Yes, this is possible due to the services running on the availability group. You can check about Failover policies and AGs here:

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/failover-policy-for-failover-cluster-instances?view=sql-server-2017

Hope this is informative for you,
Best regards,



--If the the reply is helpful, please Upvote and Accept as answer--

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.