How do you install hot-fixes, patches to sql server 2005 cluster
Posted on 2008-10-17
I am fairly new to sql server 2005 cluster and have a question regarding installing patches/hot-fixes. We have a active/active/passive cluster. This is what I believe needs to take place, please correct me if I am mistaken:
-install patch/hot-fix on node1. since cluster-aware, it will automatically install on the other 2 nodes
- the nodes will need to be bounced. Therefore, bounce node1, which cause it to failover to the passive node. When done, bouce the passive node, causing node1 to failback, repeat for node3.
What additional steps, if any, need to be performed for the non-cluster-aware components.
What steps need to be performed if you do not have any window for 'down-time'.
Lastly, what needs to be done for installs of items which are not cluster-aware, such as drivers... do they simply get installed on the local drive or will it cause a failover situation?