Patching Or Updating AlwaysOn Availability group Replicas in SQL Server Best Practices - DBA Tutorial

In this video you will learn following:

1- Patching AlwaysOn Availability Group replicas best practices
2- General Steps to update or Patch Availability Group replicas in SQL Server
3- Overview of Availability Group configuration in SQL Server
4- How to change Availability Group configuration setting according to best practices.

Patching/Updating best practices for AG Groups

1-     Make sure manual failover to one of your synchronous commit replica is successful

2-     Take backup of your database

3-     Check consistency of your Database (DBCC) and make sure you don’t get any error on all database involved in AG

4-     Upgrade Remote Replica (if any) first, then local secondary replica and primary should be updated in the end to avoid any potential application downtime

5-     Redirect your backup preferences if secondary replica which is being updated is configured to take backups, during updates, replica cannot perform backups

6-     Remove Automatic failover  from AG to prevent unintended failover during patching/upgrading

7-     If you have synchronous commit replica, manually failover AG to that secondary replica, otherwise please make sure you resume your data movement after you manually failover to asynchronous commit secondary replicas

8-     Disable any monitoring (Alerts) during Patching/Updating process

9-     Disable Replication if you configured replication with AlwaysOn Availability Group Databases

Patching Or Updating AlwaysOn Availability group Replicas in SQL Server Best Practices