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 these two procedures:



Thank you in advance.

  • 2
    What about those docs is confusing to you? They are very detailed about the steps needed to perform an AG Failover. Adding details to your question on what is confusing, or at what point you need help understanding will be necessary to answering your questions. Without that, any answer will likely be just a summary of those linked docs, which isn't likely to address your confusion.
    – AMtwo
    Nov 16, 2021 at 14:56
  • Why I can't just perform the Failover from the Failover cluster console or from the Windows Admin Console learn.microsoft.com/en-us/windows-server/manage/… I'm trying to do this via the Windows Admin Console of other GUI methods, outside of the SQL Server Management Studio. Nov 17, 2021 at 11:16
  • @SeniorSystemsEngineer as I remember it is NOT recommended doing so, you should do failover only using SSMS AG dashboard Nov 18, 2021 at 8:39


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.