SQL Server Performance

Installing MS03-031 patch on SQL 2K Cluster

Discussion in 'SQL Server Clustering' started by rinuv, Sep 14, 2004.

  1. rinuv New Member


    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.

  2. bradmcgehee New Member

    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

Share This Page