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 |
|
SQL360
Starting Member
20 Posts |
 Posted - 2008-09-18 : 12:15:48
|
| SQL server 2000 Cluster.How do I add the node back into two nodes cluster environment? The node was removed from the cluster due to some hardware issue. The hardward issue has been fixed now.Can one node have windows 2000 and another node have windows 2003?Also how can I tell if it was setup active/active or active/passive?Thank you very much for your help.SQL360 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-10-14 : 18:25:32
|
| Active/active or active/passive is just terminology we use to indicate if a node has any cluster resources on it. For a SQL Server cluster, a node is said to be passive if there isn't a SQL Server instance running on it.You can not have a Windows 2000 node mixed in with a Windows 2003 node in a cluster. In fact, all hardware and software should be the same amongst the nodes for the stability of the cluster.Once you add the node back to the cluster, you will need to reinstall SQL Server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Fixing the broken cluster