Installing MS03-031 patch on SQL 2K Cluster | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Installing MS03-031 patch on SQL 2K Cluster

Hello, 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
Webmaster
SQL-Server-Performance.Com
]]>