Installing SQLServer 2000 service packs on Clustered server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lyn.duong@gmail.com - 30 Aug 2005 04:15 GMT

Hi,

I am planning to install sql server 2000 sp4 on my clustered server
running in active/passive mode.
I plan to stop all sql services using cluster administrator, install
the service pack from the primary node and then reboot all nodes.
Are there any missing steps that need to be done or problems that
anyone has come across?

Thank
Lyn

Reply to this Message

Simon Hayes - 30 Aug 2005 11:05 GMT

The SP4 readme has a section about installing on a cluster. There are
also some updates to the readme which relate to clustered systems, so
you should probably review the latest details:

http://www.microsoft.com/sql/downloads/2000/sp4.mspx

Simon

Reply to this Message

lyn.duong@gmail.com - 31 Aug 2005 04:44 GMT

Any advice for a backout in case the installation goes wrong ?

> The SP4 readme has a section about installing on a cluster. There are
> also some updates to the readme which relate to clustered systems, so
[quoted text clipped - 3 lines]
>
> Simon

Reply to this Message

Greg D. Moore (Strider) - 31 Aug 2005 13:07 GMT

> Any advice for a backout in case the installation goes wrong ?

I tend to keep airline tickets to a small country without extradition
treaties and my passport handy. :-)

Seriously -

The article should outline it but basically, backup your system databases
and be prepared to reinstall SQL Server and restore your backups.

(Generally the user databases are unaffacted.)

Note too though if you don't already have SP3 installed, your full-text
indexes will be invalidated, so you may want to read up on backing them up
and restoring them also.

> > The SP4 readme has a section about installing on a cluster. There are
> > also some updates to the readme which relate to clustered systems, so
[quoted text clipped - 3 lines]
> >
> > Simon

Reply to this Message