Install SQL SP3 on Win2K cluster

[jaeddy]

I'm not a DBA. That said, here we go-

I have SQL2000 running on a Win2K Advanced Cluster, two nodes, one is active, the other idle awaiting failover.

I need to install SQL SP3 on the cluster and I have looked over the KB articles related to it; however, some of it is greek to me. Here is what I understand from what I've read:

1 backup (hey, even I knew that)

2 shut down any applications that use the DB or monitor it (such as HP OV), even disconnect it from the network if feasable.

3 update the active node of the cluster.

4 verify all is working, then fail over and update the 2nd node of the cluster.

Anything I'm missing here? We are updating due to the slammer worm- we avoided problems due to our fw configuration, but this ought to be done regardless.

thanks

 

[SQLBill]

Also, the setup will reset all cluster resources to the default properties for all resources in the group, REGARDLESS of whether they are related to SQL Server or not. Make sure you knote all settings before you install the service pack.

I got that from MS's Knowledge Base Article 811168. Check it out.

BTW- I have an active/passive cluster also and plan on running the SP tomorrow (Tuesday) afternoon. I'll let you know how it went. (Before anyone comments about me not having done it yet...it just got approved by the client and since I am on contract for the Federal Gov, they are VERY picky about what goes on their systems).

-SQLBill

 

[jaeddy]

I look forward to you relating your experience. Thanks.

 

[sqlturbo]

We applied SP3 to SQL2K running on a Win2K Advanced Cluster per instructions in KB article 811168 ( which match what you mention) and all went well.