Post reply

HA Failover working from SSMS, but not from WFCM

  • November 3, 2021 at 4:41 am

    #3947361

    Hi team

    I recently finished setting up a HA Group, it seems to be working as expected and I can easily failover between nodes using SSMS.

    When I try and failover using the WFCM it shows that it fails over fine, but immediately fails back to the original node:

    Cluster resource 'AG_PREPROD' of type 'SQL Server Availability Group' in clustered role 'AG_PREPROD' failed.

    Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet.

    PS: I seem to loose the "Preffered Owners" and need to set it over again and again as it does not persist.

    Everything works perfectly from SSMS though.....

     

  • November 3, 2021 at 7:22 am

    #3947389

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

    Do not use the Failover Cluster Manager to move availability groups to different nodes or to fail over availability groups. The Failover Cluster Manager is not aware of the synchronization status of the availability replicas, and doing so can lead to extended downtime. You must use Transact-SQL or SQL Server Management Studio.

  • November 3, 2021 at 8:17 am

    #3947408

    Awesome, thank you for this

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply