SQL high available failover

SQL high available failover:

Description: Most of the administrators think that the failover should do in SQL HA by the Windows Cluster, but it’s not true. we need to do the failover by the HA method which is configured in SQL.

In this article I am providing the steps to do the failover.

Steps: Please follow the steps below to do failover in HA.

As per below screen ,Secondary Don’t have any resources so patch first in secondary.

                                 

 Once patching done successful in secondary do failover resources to secondary, then  primary becomes secondary.

Do patch in other secondary now.

Failover steps:

1.      Logon to the SQL server with SQL account

2.      Go to SQL management studio.

3.      Expand availability groups as per the screen below.

4.      Right click the DB

5.      Click on Failover

6.      Click on next in introduction

7.      Select a new primary replica->next

8.      connect to replica->click next.

9.      successful

                                 

 

 
I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.