Wednesday, March 21, 2012

Rebuild one node from SQL Cluster

hi guys,
I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
is on Active/Passive config. One of the node giving problem and i am plannin
g
to rebuild it until this question strikes my mind. After rebuild, how do i
join back to existing SQL Cluster?
TIAoh...it's k...i got it
[url]http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part4/c1261.mspx[/url
]
"Adding or Removing a Cluster Node from the Virtual Server Definition
Another new feature of SQL Server 2000 failover clustering is the ability to
add or remove a cluster node from a SQL Server virtual server definition.
Adding nodes to the existing SQL Server virtual server definition performs
all the necessary operations on the new nodes (including installing binaries
,
system components, and creating services) and performs the necessary
modifications to the cluster configuration. "
"rupart" wrote:

> hi guys,
> I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
> is on Active/Passive config. One of the node giving problem and i am plann
ing
> to rebuild it until this question strikes my mind. After rebuild, how do i
> join back to existing SQL Cluster?
> TIA|||You'll get the right audience looking at this if you plst to
ms.p.sqlserver.clustering.
There are these links
http://www.microsoft.com/technet/pr...n/failclus.mspx
http://www.microsoft.com/downloads/...&displaylang=en
http://www.sql-server-performance.c...om/?kbid=301600
Which should help but some questions first.
What SP level is the OS and SQL currently at?
There are issues adding back failed nodes to SP4 level (I had them).
Also you must follow certain guidelines when evicting/adding nodes otherwise
you could render your cluster unusable.
Also have a backup plan in case this actually does happen. I restored the
critical databases to another cluster just prior to doing the actual work on
a live system just in case it all went wrong.
Also if you have access to a "virtual server system" Virtual Server 2005 or
VMWare create a system similar to you current one to try the process out.
Nik Marshall-Blank MCSD/MCDBA
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:7BE08633-F659-4B34-9F5E-806A3550CA02@.microsoft.com...
> hi guys,
> I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
> is on Active/Passive config. One of the node giving problem and i am
> planning
> to rebuild it until this question strikes my mind. After rebuild, how do i
> join back to existing SQL Cluster?
> TIA

No comments:

Post a Comment