Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajabahadur
Starting Member
1 Post |
 Posted - 2008-05-07 : 06:14:21
|
| I am trying to upgrade SQL 2000 service pack from SP3 to SP4 on windows 2000 advance server cluster nodes. We have only one instance (default) running on the cluster. I would like to do a rolling upgrade for this activity. Need to upgrade one node to SP4 and test the application integration. And then do the same with the other node.So, my query is 1)How to apply SP4 to one node (passive) in a cluster while the other node is active.2)Could applying hotfix 2187 follow the above process.Thanks,Raj |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-07 : 10:15:53
|
| SQL Server Service Packs install only on all nodes of a cluster. You will be prompted for login credentials that have admin rights to all nodes in the cluster. Windows Service Packs are not cluster aware, but really should be applied to all nodes in a timely manner (i.e. not days apart, but within a few hours at most. |
 |
|
|
|
|
|
apply SP4 on one cluster node