Waht''s the step to apply SP4 and hotfix at cluster environment

Question

Post reply

Waht''s the step to apply SP4 and hotfix at cluster environment

Wang, KT

SSC Enthusiast

Points: 152
More actions
September 16, 2005 at 9:31 am

#95240

I have a SQL 2000 with SP3 at cluster 2 notes environment. I would like to apply SP4 and Hotfix (KB899761). But, I am not sure how the steps.
(1) apply SP4 at first note (Which the note is active)
(2) Fail over SQL to 2nd note and apply SP4 at 2nd, again.
(3) Apply Hotfix at 2nd note and fail over SQL server to 1st note to apply hotfix?
Is someone can help ?
Thanks,
KT

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

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

sqletom SSC-Addicted Points: 438 More actions · Answer 1

The documentation states:

Run the service pack from the node that owns the group containing the virtual server that you plan to upgrade. This installs the service pack files on all nodes in the failover cluster.
In the Setup dialog box, type the name of the virtual server that you plan to upgrade.
Keep all nodes of the cluster online during setup. This ensures that the upgrade is applied to each node of the cluster.

Presumably you would install the hotfix on each individual node since that is the traditional method. But I am not sure and want to know myself. A CAUTIONARY NOTE: SP3a documentation for installing on a cluster was wrong and updated in KB816502 where it detailed the installation process the same way as you described it above.

Have MS changed the way the SP's and HotFixes are applied or is their documentation wrong? They have already updated it once see KB884525, presumably they would have corrected it there if the process had changed from the method documented in the original readme file.

Has anyone installed SP4 with the HotFix KB899761 on a a windows 2003 server with 8GB of ram or more? What process did you follow, did you have any problems?

Wang, KT SSC Enthusiast Points: 152 More actions · Answer 2

Do I need to apply SP4 for both note or apply one note only?

Wang, KT SSC Enthusiast Points: 152 More actions · Answer 3

HI, Just let you know that SP4 and Hotfix (KB899761) both are cluster share software. Do need to make sure all SQL resource on line. By the way, Hotfix KB899761 can be apply by all inatance at one time.