Patching SQL in a Clustered Environment

We are running a SQL within an Active Active Windows
Cluster setup. Will I run into any issues when attempting
to patch SQL with SQL SP3? Are there any issues I should
be aware of when patching the SQL cluster or any
prerequisite patches that need to be applied before
patching SQL in a cluster?
This is a rather open ended question. Are you talking about a specific
patch or just patches in general
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I am speaking of a general Serivce Pack 3a update. When dealing with virtual servers, are there any issues when applying the SP3a update?
rp
-- Rand Boyd [MSFT] wrote: --
This is a rather open ended question. Are you talking about a specific
patch or just patches in general
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Not really anything special. Make sure all nodes are online and are capable
of hosting the service. You will need to run the service pack from the node
hosting the particular instance you wish to update. If you have more than
one instance, you will need to apply the Service Pack to each instance
independantly. It is possible to run different instances at different
service pack and hotfix levels without a problem. Of course all instances
on a particular host will run against the same level MDAC installation. If
you run into any issues, you know where to find help.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Bob" <anonymous@.discussions.microsoft.com> wrote in message
news:02068577-4EB9-472E-A36E-D21EF109FC91@.microsoft.com...
> I am speaking of a general Serivce Pack 3a update. When dealing with
virtual servers, are there any issues when applying the SP3a update?
> rp
> -- Rand Boyd [MSFT] wrote: --
> This is a rather open ended question. Are you talking about a
specific
> patch or just patches in general
> Rand
> This posting is provided "as is" with no warranties and confers no
rights.
>
|||Before applying any service pack, always review the readme. For sp3a on a
cluster, see:
811168 INF: SQL Server 2000 Service Pack 3 or Service Pack 3a
Pre-Installation
http://support.microsoft.com/?id=811168
And you should strongly consider applying the MS03-031 security rollup as
well.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Cindy. I didn't know you had joined Microsoft.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com