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.