reclustering SQL Server 
Author Message
 reclustering SQL Server

We lost node two in a SQL/NT Cluster.  we have gotten that
node backup using an old Emerg repair disk, but it does
not know anything about the cluster or SQL server.  
what are the proper steps to get the servers fully
clustered again?  I have been told that doing a
SQL uncluster/recluster will fail because the second
node has no knowledge of the cluster that it used
to belong to.

thanks

John



Sat, 22 May 2004 05:59:05 GMT
 reclustering SQL Server

John,

When I had the same issue, we took the cluster offline, and put the database
onto a single server (they business where up and running) and re-built the
entire cluster from scratch. Couldn't find a nice way of having the second
node realise it was invloved in a cluster.

Hope this helps

Rob

Quote:

> We lost node two in a SQL/NT Cluster.  we have gotten that
> node backup using an old Emerg repair disk, but it does
> not know anything about the cluster or SQL server.
> what are the proper steps to get the servers fully
> clustered again?  I have been told that doing a
> SQL uncluster/recluster will fail because the second
> node has no knowledge of the cluster that it used
> to belong to.

> thanks

> John



Sat, 22 May 2004 07:06:00 GMT
 reclustering SQL Server
Which version of SQL do you have? That makes a big differentce. If it's SQL7,  you lost the second node, you can just rebulid the second node, delete the second node from NT cluster, rejoin the NT cluster,  you can just run sql cluster wizard on the first node to uncluster sql, and recluster sql with the first and second node. Make sure before you uncluster sql, shut down all the services may affect it, and remove service manager from task bar, follow the same set of rules of installation of sql cluster.
And those are all during downtime.

David Gao, MCSE, MCDBA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sat, 22 May 2004 14:24:45 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Error when reclustering a SQL Server

2. Reclustering SQL 7.0

3. Reclustering SQL 7.0

4. Problem with reclustering after Sp2

5. Ip address changed without reclustering

6. How can we avoid reclustering some indexes ??

7. how to backup a sql server 65 server from a sql server 2000 server

8. Problem connecting one SQL Server server to another SQL Server server

9. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

10. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

11. SQL server to SQL Server to Web Server

12. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro


 
Powered by phpBB® Forum Software