-1

I have created always on availability group.The cluster core resources failover is happening. The availability group (Automatic) failover is happening. But, when the cluster core resource is failed over the availability group failover is not triggered.

For example,in cluster core resource server1 is online and in AG server1 is primary replica. When the cluster core resource is failed over to server2, the AG is still in server1 as primary replica.

Why is that happening? The AG role is healthy.Please help me here.

Thank You

1

The cluster core resource can be primary in one of the nodes without affecting the singles AGs and their assignament to a specific node. It is different from a Failover cluster Instance where there is dependency from the cluster core resource and the clustered service.

I suggest you to manage AG failover inside ssms moving then with the proper wizard or by tsql query command.

Plase take a look at this:

https://docs.microsoft.com/it-it/sql/database-engine/availability-groups/windows/perform-a-planned-manual-failover-of-an-availability-group-sql-server?view=sql-server-ver15

5
  • Thank You @MBuschi. Able to perform manual failover in SSMS. So, the cluster core resource failover does not affect AG failover?
    – Sree Lekha
    Jan 15 at 7:34
  • It depends if it comes because a node went down or only a manual movement of the cluster core resource.
    – MBuschi
    Jan 15 at 9:11
  • So, if the manual cluster core resource failover is performed - then there is no affect on AG. If the primary node went down in WSFC, then the AG failover also should takes place?
    – Sree Lekha
    Jan 15 at 9:53
  • Exact, this is the behavoir
    – MBuschi
    Jan 15 at 9:55
  • Thank You @MBuschi.You helped me at perfect time.
    – Sree Lekha
    Jan 15 at 9:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.