如何在 SQL Server AOAG 设定环境之下, 套用修补程序 (patching)?

DBABootcamp

相信大家可以在网路上找到许多文章说明如何在 AlwaysOn 可用性群组 (AG) 的环境下套用修补程序。但通常都是长篇大论。在这里分享精简的步骤。

1. On Primary, change failover mode to Manual

2. Apply patches on Secondary

3. Failover AG to Secondary

4. Apply patches on Primary

5. Failover AG to Primary

6. On Primary, change failover mode to Automatic

Enjoy!