SQL Server Performance Forum – Threads Archive
Installing MS03-031 patch on SQL 2K ClusterHello, I have a question regarding installing the ms03-031 patch on a SQL 2K cluster. I don’t have much experiences with clustering. We have an active-passive cluster on Win 2K3 environment. When I install the patch, should I install it on each of the machines individually or should I just install it on the virtual server? When I installed SP3, I just installed it on the virtual server. I didn’t know if the patch should be treated the same way or differently. Thanks in advance for any assistance. Rinu
It should be installed separately on each server. Here’s what I would do: 1) Move all active cluster resources to node 1.
2) Add patch to node 2.
3) Reboot node 2.
4) Move all active cluster resources to node 2.
5) Add patch to node 1.
6) Reboot node 1.
7) Move all cluster resources to appropriate cluster node. —————————–
Brad M. McGehee, MVP