Patching Or Updating SQL Server with multiple AlwaysOn Availability Groups - DBA Tutorial

In this video you will learn following:
1- How to patch or update SQL Server instances replicas with multiple Availability groups
2- How to free up replica to patch
3- How to failover Primary replica to it's secondary replica
4- How to execute windows patch on Availability groups replicas
5- How to test Availability groups after patching or updating
6- How to resume data movement in Availability group

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/Updating SQL Server instance with multiple AG groups

Note: Change Synchronous commit to Asynchronous and Automatic Failover to Manual Failover before performing below steps

1- Free up Replica 3 and patch or update

2- Failover AG to make sure all works fine

3- Free up Replica 2

4- Failover AG to make sure all works fine

5- Free up Replica 1

6- Failover AG and see if all works ok 

How to patch SQL Server with Multiple AlwaysOn Availability Groups - SQL Server DBA Tutorial