Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

Help : How can I move Storage in Windows Cluster 2008

Posted by blakhani on June 11, 2011


While working on a case few days ago, I faced this question by customer and i found it interesting to blog about. (Today I found this in forum so finalizing and posting it). Here is the question.

I have created two node windows cluster. All disk are available in “storage” but I don’t see any option to do manual failover unless they are part of some group. How can I test if failover is working fine for disks without shutting down the node or adding them to a group.

Here is the screenshot to explain the problem better. As you can see that U and W are not part of any group defined under “Services and Applications”. So by default they are the part of “Available Storage” group.

Storage

And indeed there is no option in UI to do failover of those disks.

No Option

I spend sometime with windows team and I was able to find the answer. so here it goes.
This can only be done by command line. We need to use cluster.exe command to achieve this.

Cluster Group “Available Storage” /Move:NodeName

In above command NodeName is optional. If you have two nodes, it would move storage automatically to other node.

Move Using Command

Hope this would help someone in the world!

Cheers,
Balmukund Lakhani
Twitter @blakhani

Advertisements

7 Responses to “Help : How can I move Storage in Windows Cluster 2008”

  1. Edwin Sarmiento said

    Great post. This is very useful when dealing with Windows Server 2008 clusters as they don’t have the PowerShell modules for Windows Failover Clustering like they do in WIndows Server 2008 R2

  2. john said

    Thank you so much. I have a live production service and it failed because the disk groups where not setup correctly. with the above I managed to move it across temporarily during the day!

  3. Mary said

    Worked like a charm!! Thank you so much!!!!

  4. eyas gazal said

    wallah ennak 3arasee yaman thank youu very much ♥♥♥

  5. Biku said

    Great Post

  6. Channdeep Singh said

    In case, the command shown by Balu sir in command window says “syntax error”; then please add cluster name in command and it will work.

    cluster “cluster name” group “group name” /move:nodename

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: