RE: Installing Service Pack on multiple instance cluster

From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 10/22/04 

Date: Fri, 22 Oct 2004 05:18:36 GMT

Hi Alex,

First of all, I would like to show my gratitude for Mike's suggestion and
here is some additional information for your convenience from readme.exe of
SQL Server 2000 Service Pack 3a

To install the service pack on a failover cluster
 - If any resources have been added with dependencies on SQL Server
resources, those dependencies must either be removed or taken offline
before you install SP3a. If you do not do this, the installation of SP3a
may cause those dependent resources to fail over.

 - Run the service pack from the node that owns the group containing the
virtual server that you are going 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
are upgrading.

 - Keep all nodes of the cluster online during setup. This ensures that the
upgrade is applied to each node of the cluster.

 - If you removed dependencies or took resources offline in Step 1 above,
add back the dependencies or bring the resources back online.

Note Setup might require rebooting of the failover cluster nodes. This
replaces the files that were in use during setup with the updated files.

More detailed information about this could be found in the following site

3.10 Installing on a Failover Cluster
http://support.microsoft.com/?scid=http%3a%2f%2fsupport.microsoft.com%2fsupp
ort%2fservicepacks%2fsql%2f2000%2fsp3readme.asp#_installing_on_a_failover_cl
uster

INF: How to Obtain the Latest SQL Server 2000 Service Pack
http://support.microsoft.com/default.aspx?scid=kb;en-us;290211

Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
 

Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Relevant Pages

  • RE: Problem installing SP4
    ... Verify that there are no dependencies other than those created by the SQL Server setup on any SQL Server cluster resources. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Who is using MSMQ?
    ... I understand about the dependencies; ... the SQL Server Service Manager are the same ones you get from the Windows ... about MSMQ and MSMQTriggers? ...
    (microsoft.public.sqlserver.security)
  • Re: SP3a on cluster...help please
    ... If you have all nodes online, the SP install will work 'cluster-wide' on all ... remember to start the service pack from the node that currently owns the SQL ... I support the Professional Association for SQL Server ... > "While performing the cluster portion of SQL Server 2000> SP3 or SP3a, the setup will reset all cluster resources to> the default properties for all resources in the group,> whether they are related to SQL Server or not." ...
    (microsoft.public.sqlserver.clustering)
  • RE: URGENT: evciting cluster node
    ... BEFORE evicting the primary node, run SQL Server setup on the secondary node and remove the primary node from SQL Failover cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBSMonitoring and Sharepoint DB Movement
    ... Installing a ful blown version of SQL server will not neecssarilly save more ... resources than taking the approach mentioned above. ... Sql Server/MSDE instances on SBS: ... sbsmonitoring/sharepoint databases that are installed by default in SBS ...
    (microsoft.public.windows.server.sbs)