Installing sp2 on active/passive cluster

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "geekyguy" <geeky@xxxxxxx>
Date: Mon, 31 Mar 2008 12:35:28 -0400

According to the sp2 readme:

3.2.5 Installing SQL Server 2005 SP2 on a Failover Cluster Instance
Note the following information before you install SP2 on a failover cluster instance:
Do not stop the cluster service before you run the SP2 Setup program, or while the installation program is running.
Do not end any running processes before you run the SP2 Setup program.
Do not take the SQL Server service off line before you run the SP2 Setup program. The SP2 Setup program will stop and start the SQL Server service.
Run the SP2 Setup program on the primary node of the failover cluster instance.
You must restart all failover cluster nodes after SP2 is finished installing.
Rolling upgrade is not supported for SP2.

I just want to make sure this is all I really have to do? I've read elsewhere that non-cluster-aware SQL components like Workstation Components/SMS will not be updated on the passive server unless I run sp2 on that server after running it on the active node?

I want to get this right the first time!

.

Follow-Ups:
- Re: Installing sp2 on active/passive cluster
  - From: Geoff N. Hiten

Prev by Date: Re: Trying to Move Group - SQL Instance Won't Start
Next by Date: 2 active instances on 2 nodes at the same time SQL 2k5 Standard
Previous by thread: running sql 2005 sp2 on pre-sp1 cluster?
Next by thread: Re: Installing sp2 on active/passive cluster
Index(es):
- Date
- Thread

Relevant Pages

RE: Qry Analyzer Debug broken: XP SP2
... I am trying to debug a sql server, from a WinXP sp2 system. ... this prior to installing XP sp2 on the WinXP system. ... > Based on my scope, as you said it is a remotely debugging,does it used a ...
(microsoft.public.sqlserver.server)
Microsoft SQL Server 2005 SP2 Issue
... An issue was recently discovered with SQL Server 2005 SP2 which might impact ... primarily for customers who use cleanup tasks in maintenance plans and SQL ...
(microsoft.public.sqlserver.tools)
Microsoft SQL Server 2005 SP2 Issue
... An issue was recently discovered with SQL Server 2005 SP2 which might impact ... primarily for customers who use cleanup tasks in maintenance plans and SQL ...
(microsoft.public.sqlserver.setup)
RE: Determining AS 2005 Version/Edition
... I will try upgrading to SP2. ... Summary pane of SQL Server 2005 to the property menu of the server ... regional support phone numbers. ... Microsoft Online Community Support ...
(microsoft.public.sqlserver.olap)
Re: Maintenance Plan Changes in SQL Server 2005 SP2
... SP2 that affects existing cleanup tasks until updated using SQL Server SP2 ... You are affected if you use SQL Server 2005 maintenance plans, ... include a History Cleanup Task or a Maintenance Cleanup Task, ...
(microsoft.public.sqlserver.tools)