Evicting a Node in a Cluster Can Cause Problems in SQL 6.5 or 7.0

Article translations Article translations
Article ID: 225092 - View products that this article applies to.
This article was previously published under Q225092
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SUMMARY

It may seem easy to troubleshoot a node in a cluster by evicting the node and reinstalling the cluster service. This process can be disastrous to the SQL Virtual Machine and make you reinstall SQL 6.5 or 7.0.

MORE INFORMATION

Normally evicting a cluster node is not a problem. Reinstalling the cluster and joining the other node typically replicates the proper entries. However, when an SQL virtual machine is involved, it becomes complex.

Before you evict a Cluster Node running SQL, you must uninstall the SQL Virtual Machine first. The process is to run the cluster Wizard for SQL Virtual machine (not the SQL install) and uncluster SQL on both nodes. The path on the SQL CD-ROMs are:
SQL 6.5 = \i386\cluster
SQL 7.0 = \x86\cluster
For Alpha computers, it would be in the Alpha folders.

Changing the name of the computer forces an eviction and has a similar effect because after the computer name is changed, it does not communicate with the other node.

The evict a node, follow these steps:
  1. In Cluster Administrator, right-click the node name.
  2. Click Evict Node.
NOTE: If you evict a node like this while running an SQL Virtual cluster, you need to completely reinstall SQL.

Properties

Article ID: 225092 - Last Review: October 20, 2013 - Revision: 1.1
APPLIES TO
  • Microsoft Windows NT Server 4.0 Enterprise Edition
Keywords: 
kbnosurvey kbarchive kbenv kbfaq kbinfo kbinterop kbnofix KB225092

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com