AlwaysOn

Question

Hi,

Can anyone assist on query ?

If the always on AG group is in resolving state . At cluster level ,the role is in error or missing .

Does this needs to be solved at Sql level or Window cluster level first . 

My understanding is first cluster need to be fixed as AG sits on top of Cluster 

Thanks

Aslam

Answer 1

Any one ?

Answer 2

On failover cluster window does it show in failed state? Can you check whether SQL service and AG are in same node? If not then you need to manually failover AG to the SQL service node.

Answer 3

Hi Aslam,

Please check the error log and cluster logs to find the reason. Please refer to Diagnose Unexpected Failover or Availability Group in RESOLVING State. Hope it could help you.

Best regards,
Cathy 

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact [e-mail]

Answer 4

Hi Aslam,

Yes, it can either both ways fix the issue for initial analysis, The SQL AOG registry is resides on WFCS, Prior you need to verify The SQL logs and WFCS logs, And then take the decision for fixing the issue.

@https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-2017

---

Regards, Kiron