0

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:

https://docs.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://docs.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.

3
  • 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 '21 at 14:56
  • Why I can't just perform the Failover from the Failover cluster console or from the Windows Admin Console docs.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 '21 at 11:16
  • @SeniorSystemsEngineer as I remember it is NOT recommended doing so, you should do failover only using SSMS AG dashboard Nov 18 '21 at 8:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.