RE: URGENT: evciting cluster node

From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 10/01/04


Date: Fri, 01 Oct 2004 18:35:20 GMT

Hi Nik,

Here are the steps that should be used

1) BEFORE evicting the primary node, run SQL Server setup on the secondary node and remove the primary node from SQL Failover cluster. The steps are given in BOL. I am cutting and pasting it below.

 
How to remove a node from an existing failover cluster (Setup)
=======================================================
On the Welcome screen of the Microsoft SQL Server Installation Wizard, click Next.
On the Computer Name screen, click Virtual Server and specify the name of the server from which to remove the node. Click Next.
You may see an error message saying that one (or more) of the nodes of the Microsoft® Windows NT® 4.0 or Microsoft Windows® 2000 cluster are unavailable. This may be because the node(s) you are attempting
to remove is damaged. The node(s) still can be removed. Click OK.
On the Installation Selection screen, click Advanced Options. Click Next.
On the Advanced Options screen, click Maintain a virtual server for failover clustering. Click Next.
On the Failover Clustering screen, click Next.
You do not need to modify any IP address(es).
On the Cluster Management screen, select the node and click Remove. Click Next.
On the Remote Information screen, enter login credentials for the remote cluster node that has administrator privileges on the remote node(s) of the cluster. Click Next.
On the Setup Complete screen, click Finish.
If you are instructed to restart the computer, do so now. It is important to read the message from SQL Server Setup when you are done with installation. Failure to restart any of the specified nodes may cause failures
when you run the Setup program in the future on any node in the failover cluster.

2) Evict primary node from Cluster Administrator.

3)Fix the primary node

4) Join the primary node to the existing cluster.

5) Run SQL Server 2000 Setup program on secondary node and add the primary node back to the failover cluster.

6) Run any SQL Server service packs and security patches/hotfixes on the primary node.

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx



Relevant Pages

  • RE: Need help with proper cluster node uninstall...help needed!!
    ... You will need to remove the node from the existing SQL Server 2000 virtual Failover Cluster by following these steps: ... Run SQL Server 2000 EE Setup on the node where SQL Server is currently running. ... On the Welcome screen of the Microsoft SQL Server Installation Wizard, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering SQL 2000
    ... O> another application in the failover cluster. ... You can setup the new instance by simply using SQL Server ... Be sure to evaluate rigorously how memory and CPU resources ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cant get SQL 2000 installed on new node in Cluster
    ... How to remove a node from an existing failover cluster (Setup) ... On the Welcome screen of the Microsoft SQL Server Installation Wizard, ...
    (microsoft.public.sqlserver.clustering)
  • RE: Installing an sql server 2008 cluster on server 2008 from scratch
    ... when using the Advanced Cluster Preparation settings are ... On the installation screen we have two options ... New SQL SERVER failover cluster installation. ...
    (microsoft.public.sqlserver.clustering)
  • Installing an sql server 2008 cluster on server 2008 from scratch
    ... New SQL SERVER failover cluster installation. ... Launch a wizard to install a single-node SQL SERVER 2008 failover cluster. ...
    (microsoft.public.sqlserver.clustering)