SQL Always On Environment:
Apply a SQL Service Pack or hot-fix in SQL Server Always-On environment.
Primary SQL Replica: SQLDBANOWDBALABS
Secondary SQL Replica: SQLDBANOWDBALABS-DR
Apply SP/Hot-fix on all Secondary AG Replica's
Finally Apply SP/Hot-fix on Primary AG Replica.
1. On Secondary AG Replica: (SQLDBANOWDBALABS-DR)
Ensure AG Databases are in Synchronized Status.
Apply the SQL Service Pack on Secondary Replica Server. (SQLDBANOWDBALABS-DR)
Post SP/hot-fix installation completion, restart the Secondary Replica Server if prompted.
2. On Primary AG Replica: (SQLDBANOWDBALABS)
Failover the SQL AG Group from Primary Replica to Secondary Replica.
3. Post AG Group Failover:
New Primary Replica : SQLDBANOWDBALABS-DR
New Secondary Replica: SQLDBANOWDBALABS
4. On New Secondary AG Replica: (SQLDBANOWDBALABS)
Apply the SQL Service pack on New Secondary Replica Server. (SQLDBANOWDBALABS)
Post SP/hot-fix installation completion, restart the New Secondary Replica Server if prompted.
5. On New Primary AG Replica: (SQLDBANOWDBALABS-DR)
Failback the SQL AG Group from Primary to Secondary Replica.
6. Post AG Group Failback:
Primary Replica : SQLDBANOWDBALABS
Secondary Replica: SQLDBANOWDBALABS-DR
7. Finally verify the SQL AG Group Health Check in AG DashBoard Reports.
No comments:
Post a Comment