Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Feb 2, 2005

Rebuilding SQL Server Cluster Nodes

By Muthusamy Anantha Kumar aka The MAK

Active/Passive SQL Server 2000 clustering gives more reliability and fault tolerance to Production SQL Server environments. When a failure occurs, all of the resources fail over from the active node to the passive node and make the passive node active. This article explains how to rebuild the node that failed and attach it back to the cluster.

First, let's assume we have the CLUSTER server "VCLUSTER" with nodes "SQLNode1" and "SQLNode2." Further, we will assume the virtual name of the SQL server is SQLCLUSTERA and that VCLUSTER, SQLNode1, SQLNode2 and SQLCLUSTERA belong to the same domain "VDOMAIN."

In this example, the node "SQLNode1" has failed due to a major hardware failure, including local hard disks. Now all the failed resources have failed over from SQLNode1 to SQLNode2. [Refer Fig 1.0]

Step 1 - Evicting the failed node

Open the Cluster Administrator and evict the node "SQLNode1" from the cluster "VCLUSTER." [Fig 1.1 and 1.2]

[Fig 1.1]

[Fig 1.2]

Step 2 - Install new hardware, network and update IP address.

Install new hardware, replacing the failed hardware and install the operating system in node "SQLNode1." After that, you have to setup a Public and Private network. [Refer Fig 1.3]

[Fig 1.3]

Verify the IP Address from the DNS [Fig 1.31] and update the IP information of the Public network.

[Fig 1.31]

Update the IP address of the private network as well.

Step 3 - Add the node "SQLNode1" to the domain.

Update the machine name and add the machine to the domain. [Refer Fig 1.4 and 1.5]

[Fig 1.4]

[Fig 1.5]

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM