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

Improve this question
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, 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.
    – Senior Systems Engineer
    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
    – Aleksey Vitsko
    Nov 18, 2021 at 8:39

0

Reset to default

Your Answer

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