I have a cluster running SQL 2000 on Win 2000. I need to install sp3a
on the cluster.Is there any special area that I have to be careful
about.?Any links
or suggestions will be greatly aprreciated.

Thanks
Joel

Hi Joel,

The following has some useful information
811168 INF: Pre-Installation Checklist for SQL Server 2000 Virtual Server
for
http://support.microsoft.com/?id=811168

Regards,
Clive Challinor [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.

Joel,

From this KB article :

INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?id=254321

comes this :

SQL Server 6.5 or 7.0
You must uncluster SQL Server to install SQL Server service packs. You
must also remove replication before you uncluster SQL Server, which is
noted in the "Replication Issues" section of this article.
SQL Server 2000
With SQL Server 2000, there is no un-clustering. You just start the
service pack installation from the node that is in control of the SQL
Server that you want to upgrade.

NOTE: You can install Microsoft Windows NT service packs in the usual
manner as described in the following article in the Microsoft
Knowledge Base:
174799 How to Install Service Packs in a Cluster


Regards,

Paul Lynch
MCSE

Hi,

Thank you very much for the posting.I have another question :

The sp3a files which is to be used for installation (acc: to MS)are
Sql2ksp3.exe. Updates for database components.
Sql2kasp3.exe. Updates for Analysis Services components.
Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).

I was wondering whther I just need to use only the first file ???
Since I dont have analysis services , so I don't need the second
file.I wanted to know whether MSDE 2000 was installed in my system(I
was not there when
the cluster was built) so I tried microsoft's recommendation
http://support.microsoft.com/?kbid=311762

But I couldnt find any registry information.
Doesnt that indicate that MSDE is not present or is it that MSDE will
always be present with a SQL installation ?

Can anyone give info on this, please ?

Thanks
Joel

================================================== ===
Paul Lynch <paul.lynch (AT) nospam (DOT) com> wrote

This is an old post and hopefully you might have found the answers. But I
did not see anybody reply to your qs. So, just in case you still need the
answers, here they are....

See answer inline.......

Hi,

Thank you very much for the posting.I have another question :

The sp3a files which is to be used for installation (acc: to MS)are
Sql2ksp3.exe. Updates for database components.
Sql2kasp3.exe. Updates for Analysis Services components.
Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).

I was wondering whther I just need to use only the first file ???
Since I dont have analysis services , so I don't need the second
file.

<uttam> You are correct. You just need the first file </uttam>


I wanted to know whether MSDE 2000 was installed in my system(I
was not there when
the cluster was built) so I tried microsoft's recommendation
http://support.microsoft.com/?kbid=311762

But I couldnt find any registry information.
Doesnt that indicate that MSDE is not present or is it that MSDE will
always be present with a SQL installation ?
Can anyone give info on this, please ?

<uttam> If you followed the KB and did not find it then you don't have MSDE
installed. MSDE is not present with a SQL installation. There is a seperate
setup file for MSDE.</uttam>

Thanks
Joel



Regards,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
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.