Re: How to install service pack 3a on a failover cluster
From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 11/19/04
- Next message: James: "Installing SQL to a SAN"
- Previous message: Derek: "Re: Migrate from non-cluster to Cluster"
- In reply to: Rodney R. Fournier [MVP]: "Re: How to install service pack 3a on a failover cluster"
- Next in thread: pepe: "Re: How to install service pack 3a on a failover cluster"
- Reply: pepe: "Re: How to install service pack 3a on a failover cluster"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Nov 2004 06:52:41 GMT
The steps for installing service pack 3a is documented in the Readme for service pack 3a.
I am cutting and pasting it for your reference. Hope that helps.
(http://support.microsoft.com/default.aspx?scid=/support/servicepacks/sql/2000/sp3readme.asp#_installing_on_a_failover_cluster)
3.10 Installing on a Failover Cluster
The following information applies only to SQL Server 2000 components that are part of a failover cluster.
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.
If you are upgrading a default (non-clustered) instance of SQL Server to a virtual server, first, you must upgrade the default (non-clustered) instance to a virtual instance, and then apply SP3a. For more information
about upgrading, see "How to upgrade from a default instance to a default clustered instance of SQL Server 2000 (Setup)" in SQL Server Books Online.
For additional information on installing SP3a on a failover cluster, see Knowledge Base article 811168.
If you need to rebuild a node in the failover cluster, perform the following steps
Rebuild the node in the failover cluster. For more information about rebuilding a node, see "How to recover from failover cluster failure in Scenario 1" in SQL Server Books Online.
Run the original SQL Server 2000 Setup program to add the node back to the failover cluster.
Run SP3a Setup on the newly added node. This will update to SP3a only the binaries on the new node.
Note If you run Setup from the node where the virtual server is running, you must reapply SP3a to all the nodes. You must also rerun the database upgrade scripts.
When installing Analysis Services SP3a on a cluster, each instance must be upgraded separately.
To install SP3a on an Analysis Services cluster
Install SP3a on a failover node.
Fail over to the newly upgraded node.
Repeat steps 1 and 2 until all instances in the cluster are upgraded.
Additional Information
==================
Support WebCast: Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack Installation
Article ID : 325485 Last Review : August 9, 2004 Revision : 5.3 This article was previously published under Q325485Session Summary This is an entry-level walkthrough on the installation of a named-instance SQL
Server 2000 virtual server. Topics covered will include: MS DTC installation on
http://support.microsoft.com/default.aspx?scid=kb;en-us;325485
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
- Next message: James: "Installing SQL to a SAN"
- Previous message: Derek: "Re: Migrate from non-cluster to Cluster"
- In reply to: Rodney R. Fournier [MVP]: "Re: How to install service pack 3a on a failover cluster"
- Next in thread: pepe: "Re: How to install service pack 3a on a failover cluster"
- Reply: pepe: "Re: How to install service pack 3a on a failover cluster"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
