Nodes have same hotfixes

  • What is the easy way to insure all nodes in a cluster have same hotfix's applied?

    I can check using select @@version?

  • That is probably the easiest way, but if you are asking about a cluster you have to fail the cluster over to each node and re-run it because they all have their own copy of the software..

    CEWII

  • It is on a cluster, can you elaborate on the steps I would need to take?

  • How many instances do you have in the cluster? When you apply a hotfix for SQL Server 2005 in a cluster, all nodes are updated for the specified instance.

    You only need to worry about node specific applications such as SSMS, SSIS and SSRS. Those components need to be upgraded individually on each node.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Thanks!!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply