SQL Cluster Environment:
Apply a SQL Service Pack or hot-fix in a 2 node Active/Passive SQL Cluster environment.
Active SQL Server: SQLDBANOWDBALABS
Passive SQL Server: SQLDBANOWDBALABS-DR
1. First apply the SQL Service Pack on Passive Server. (SQLDBANOWDBALABS-DR)
2. Post SP/hot-fix installation completion, restart the Passive Server if prompted.
3. Failover the SQL Cluster Service/Instance from Active to Passive Server.
Post Failover:
New Active Server: SQLDBANOWDBALABS-DR
New Passive Server: SQLDBANOWDBALABS
4. Now apply the SQL Service pack on New Passive Server. (SQLDBANOWDBALABS)
5. Post SP/hot-fix installation completion, restart the New Passive Server if prompted.
6. Failback the SQL Cluster Service/Instance from Active to Passive Server.
Post Failback:
Active Server: SQLDBANOWDBALABS
Passive Server: SQLDBANOWDBALABS-DR
7. Finally verify the SQL Cluster Services and Cluster Disk Health Check in Failover Cluster Manager.
No comments:
Post a Comment