This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi people,
I need some steps and guidance, to perform the Microsoft Cluster Failover (MSCS 2016) for my SQL Server 2017 Enterprise Edition – Always-On 2x nodes.
This is to perform the Windows Server updates that will be rebooting one SQL Server node over the other.
I got confused between:
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/use-the-fail-over-availability-group-wizard-sql-server-management-studio?view=sql-server-ver15
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/perform-a-planned-manual-failover-of-an-availability-group-sql-server?view=sql-server-ver15
Thank you in advance.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi EnterpriseArchitect,
How are things going?
Do the answers help you?
Please feel free to let us know if you have any other question.
If the post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia
There is a article regarding this in contrast to what you have shared. You can try the steps and see how it goes.
Once you have done with this then you can try the steps as per this article
-----
--If the reply is helpful, please Upvote and Accept it as an answer--
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
These steps apply for all upgrade and patching activities for all clusters.
Hi EnterpriseArchitect,
Do you mean you want to failover a SQL Server Always on Availability Group so that you can update the Windows Server? If I misunderstood, please let me know.
Before failing over the AG, please verify that the synchronization state of the failover target is SYNCHRONIZED, and make sure the secondary replica and the primary replica are running in synchronous-commit availability mode. Please update the OS of secondary replica first, then you can failover the Alwayson, update the OS of new secondary replica (old primary replica).
You can go to primary replica, expand the AlwaysOn High Availability node -> Availability Groups -> right-click the availability group ->select Failover to perform a manual failover.
Then please follow the doc to use Fail Over Availability Group Wizard to failover.
Please also check Upgrading Always On Availability Group Replica Instances which might be helpful.
Best Regards,
Amelia
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi, @AmeliaGu-MSFT Yes, I wanted to perform the node update.
So how do I check the Synchronized status?
Hi EnterpriseArchitect,
Thanks for your reply.
So how do I check the Synchronized status?
You can go to primary replica, expand the Always On High Availability ->Availability Groups ->
Right-click the availability group -> Properties.
Check the availability mode in the Availability Replica Properties dialog box-> Availability mode.
I'm trying to do this via the Windows Admin Console of other GUI methods, outside of the SQL Server Management Studio.
It is not recommended to failover the SQL Server Always on Availability Group outside of SSMS. Please go to SSMS to failover Always on.
Best Regards,
Amelia
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @AmeliaGu-MSFT , where can I find the synchronization state of the failover target is SYNCHRONIZED?
Hi EnterpriseArchitect,
Thanks for your reply.
You can go to the target replica, expand the Database, then we can check if the database is in SYNCHRONIZED.
You can also go to expand the Always On High Availability ->right-click the Availability Groups -> Show Dashboard to check the health of an availability group and its availability replicas and databases.
Best Regards,
Amelia
@AmeliaGu-MSFT , many thanks for the detailed explanation. Therefore, for my regular patching schedule, the recommended procedure to failover without data loss for the SQL Server AlwaysOn AG is using the Fail Over Wizard from SSMS https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/use-the-fail-over-availability-group-wizard-sql-server-management-studio?view=sql-server-ver15?
Because, even with the Planned manual Failover method, the Failover wizard will determine if there will be data loss or not.
Hi EnterpriseArchitect,
Thanks for your reply.
Because, even with the Planned manual Failover method, the Failover wizard will determine if there will be data loss or not.
There will be no data loss when planned manual failover happened if both the primary replica and secondary replica are configured for synchronous-commit mode, and both the primary replica and secondary replica are currently synchronized.
Please refer to this doc which might be helpful.
Best Regards,
Amelia
