none
AlwaysOn RRS feed

  • 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

    Friday, August 23, 2019 10:08 PM

All replies

  • Any one ?
    Saturday, August 24, 2019 2:34 PM
  • 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.
    Saturday, August 24, 2019 2:39 PM
  • 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 MSDNFSF@microsoft.com

    Monday, August 26, 2019 7:32 AM
  • 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

    Monday, August 26, 2019 7:56 AM