Hi ,
quite a basic question here, but I like to have a confirmation .
I need to install SP2 on a Clustered Sql2005 .
The cluster has 3 instances .
Question is , can I install SP2 over just one of them without affecting the
others in any way ?
When I run the Sp2 setup on a node , and select hopefully the instance which
I want to update , is the other node updated automatically as well ?
thanks

Stefano

I'm not an expert of Clustering as Geoff or Tom are, my undestanding is that
you apply SP per intance and as you say youhave three , so you need run SP2
three times

The other node that does not have SQL Server will be updated  as (binaries
go thru)

Show quote

Hide quote

One of the nice improvements the SQL team built into SQL 2005 is an improved
Service Pack/Hotfix installer.  You can now choose components and instances
independently.  So you can apply SP2 to one instance of the database engine,
but leave everything else alone.  Or you can do all the instances at once
(something you could not do before).  You will need to run the SP on each
node independently to get the non-cluster-aware components such as SSIS and
client tools.  THe installer will leave any instances you don't want to
upgrade alone.

Show quote

Hide quote

SQL Server 2000 download?
Computed Column Formulas
Performance monitoring specific database
-- error al crear plan de mantenimiento --
High Pagelatch and threadpool