Patching or Updating Availability Group with SQL Server Failover Cluster Instance Part 2 - DBA Tutorial

In this video you will learn following:

1- Patching or updating Availability Group replicas when SQL Server is installed in Cluster mode
2- How to failover SQL Server instance from one node to another node in SQL Server?
3- How to apply Patch on secondary replica when Availability Group is setup on the server?
4- How to check if availability group is working fine after patching on secondary replica?
5- How to resume database movement in SQL Server Availability group?
6- How to failover SQL Server resources from one node to another node?



General process steps


1-     Remove Automatic Failover on all synchronous-commit secondary replicas
2-     Upgrade all remote and secondary nodes
3-     Manually failover AG to updated secondary replica
4-     Make sure everything is working fine before you start primary replica
5-     Update primary replica
6-     Manually failback AG to primary replica
7-     Make sure everything is working fine
8-     Configure automatic failover, synchronous commit as it was before upgrade/patching

Patching/Updating AG with one Remote Secondary


1-     Change Synchronous commit to Asynchronous commit (If Any)
2-     Change Automatic Failover to Manual Failover
3-     Make sure AG Group is on Primary Replica
4-     Upgrade Secondary Replica (Remote Secondary)
5-     Failover over to secondary Replica (Remote)
6-     Upgrade Primary Replica
7-     Failback AG to Primary Replica
8-     Set Synchronous commit and Automatic Failover as it was before upgrade

Patching/Updating AG with Failover Cluster Instance





CLT01
CLT02
AG

NY01
NY02

1-     Failover SQL Server instance/instances to CLT01
2-     Upgrade CLT02
3-     Failover SQL Server instances on CLT02
4-     Make sure All works fine
5-     Repeat the process for NY01 and NY02
6-     Manual failover AG to NY instances from CLT

7-     Make sure all works fine. 

Patching or Updating Availability Group with SQL Server Failover Cluster Instance Part 2 - DBA Tutorial