Sql-server – SQL Server: Multiple Availability Groups, one cluster, how to keep the primary cluster node as primary

availability-groupsclusteringsql server

I have a database server setup where there are three SQL Server database instances set up on three nodes of a Windows Server Failover Cluster (WSFC).

The sysadmin, who is responsible for the Windows Cluster, is accusing me of manually setting the primary cluster node as something other than what it is.

Can failing Availability Groups over to secondary replicas, to include during reboots when they automatically take over, also cause the underlying Windows Server Failover Cluster to switch the primary node and not switch it back?

This has the potential to become a distracting issue, keeping me from getting work done. I'm hoping to be pointed in the right direction to keep this from happening again.

Best Answer

Converted from comments:

Are you referring to the core cluster resources? If yes, the answer is no, failover of the cluster role for the availability group would not impact the core cluster resources. The core cluster resources will of course fail over to another node if the current owner is rebooted or loses connectivity, but that behavior is not impacted by what anything that happens with the AG resources. – Tony Hinkle

Related Question