Here I will explain how to apply Service pack or CU in SQL server 2005 cluster.
Lets assume there are two nodes with Active/Active and SQL is rnning on both the nodes
Follow below steps to apply service pack or CU.
Lets assume there are two nodes with Active/Active and SQL is rnning on both the nodes
Follow below steps to apply service pack or CU.
1. Make sure media is available in C drive on both
nodes .
2. Make sure all SQL instances are
running on the same node. If it is Active/Active node, failover instance from
one Active node (B) to other Active node (A) to make other node as passive (B).
3. After failover validate all SQL
instances are up and running
4. Pause passive node (B) in cluster
admin.
5. First apply Service pack/CU on
active node (A). Since the passive node (B) is paused, the installer won’t be
able to do anything on the passive node.
6. Double click on media and follow steps on active node (A)
Note: If you want to apply Service pack or CU only for specific instance, then select only that instance otherwise select all instance to apply patch.
7. Once the installation is finished,
and if it asks for Server reboot
8. Resume passive node (B) in cluster admin.
9. Fail over all the instances from
Active node (A) to passive node (B).
10. Now Active (A) becomes passive and
Passive (B) becomes Active
11. Reboot passive node (A).
12. Now We need to apply patch on
current Active node (B)
13. Pause Passive node (A) in cluster admin
14. Double click on media and follow steps on active node (B)
15. Now the patching is completed on
Active node (B).
16. If reboot is required, then resume
Passive node (A) then fail backup all instances from Active node (B) to Passive
node (A).
17. Now reboot passive node (B).
18. Once the passive node comes up,
connect all SQL instances and verify the SQL Services are DBs and also check
version of all SQL instances.
19. Now fail back all SQL resources to its intended nodes
No comments:
Post a Comment