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 |
|
wkk1020
Starting Member
2 Posts |
 Posted - 2007-12-04 : 04:38:15
|
| Hi all, we are thinking to apply SQL Server 2000 SP4 to a clusteredSQL Server 2000 Enterprise Edition with 2 nodes. But one of the clustered nodes is permanently shut down, therefore, can the service pack installation proceed with one of the cluster nodesdown??Or should we remove the dead node from the cluster setup (through Cluster Administrator)??Thank you. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-04 : 23:00:06
|
| Should take that node out from cluster first. |
 |
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-12-05 : 10:30:29
|
| Yes, you need to update the SQL server cluster configuration via setup prior to installing the service pack. You need to run SQL setup and remove the dead node from it's list of available nodes to use. You should also evict it at that point from the MSCS cluster as well - to be thourough. It's not an absolute neccessity though...Books Online has detailed information on how to remove a node from an sql cluster. |
|
|
|
|
|
|
Applying SP4 on cluster with dead node