SQL AG shown in WFCS

John JY 221 Reputation points
2021-09-21T14:17:38.4+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,808 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
962 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-09-22T06:09:17.677+00:00

    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.

    0 comments
  2. Limitless Technology 39,391 Reputation points
    2021-09-22T08:48:52.73+00:00

    Hello @John JY ,

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

    https://learn.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--

    0 comments