Groups | Blog | Home
all groups > sql server clustering > september 2006 >

sql server clustering : Cluster Taken Offline Accidentally


Pinal-1
9/14/2006 4:14:21 PM
I have a two node cluster, and both nodes are up (this is a testing
environment) - both Virtual SQL servers are up as well. The cluster
resources are in their own group (ie, cluster IP, cluster name, Q drive,
etc). The question is...



How do you restore this Cluster Resource Group if it has accidentally been
taken offline and neither node can connect to it, since the IP, name, a Q
drive have been taken offline?



The cluster server service is running on both nodes. The issue is - since
the IP address (it cannot even be pinged), clus name and Q drive were taken
offline, how do you then re-connect to the cluster group via Cluster
Administrator to turn them back online, when the Cluster Administrator can't
connect to it?



I've looked at the following kb article - changing the persistive state
didn't seem to do anything.

http://support.microsoft.com/kb/259243/en-us



Is there any way of bringing the IP (and Q drive) online outside of cluster
administrator?

Tom Moreau
9/14/2006 7:22:07 PM
Can you use RDP to connect to one of the nodes and run Cluster Admin from
there?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
[quoted text, click to view]
I have a two node cluster, and both nodes are up (this is a testing
environment) - both Virtual SQL servers are up as well. The cluster
resources are in their own group (ie, cluster IP, cluster name, Q drive,
etc). The question is...



How do you restore this Cluster Resource Group if it has accidentally been
taken offline and neither node can connect to it, since the IP, name, a Q
drive have been taken offline?



The cluster server service is running on both nodes. The issue is - since
the IP address (it cannot even be pinged), clus name and Q drive were taken
offline, how do you then re-connect to the cluster group via Cluster
Administrator to turn them back online, when the Cluster Administrator can't
connect to it?



I've looked at the following kb article - changing the persistive state
didn't seem to do anything.

http://support.microsoft.com/kb/259243/en-us



Is there any way of bringing the IP (and Q drive) online outside of cluster
administrator?

Rodney R. Fournier [MVP]
9/14/2006 7:58:25 PM
Connect to one of the nodes using RDP.
Start Cluster Administrator.
Use a period (.) for the cluster name.
Bring the group back online.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


[quoted text, click to view]

Pinal-1
9/19/2006 8:39:25 AM
That did it! Thank you very much!


"Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in
message news:%23ch$RIG2GHA.4748@TK2MSFTNGP04.phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button