Command Line to failover cluster....

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Command Line to failover cluster....

Author

Topic

rlaubert
Yak Posting Veteran

96 Posts

Posted - 2008-07-30 : 09:29:54

Please don't shoot me... but the boss wants to failover the cluster every night to 'correct' a performance issue. And I don't want to be up at 1 AM to manually failover the cluster, so, I am looking for the command to use in a batch that I can schedule. I looked in BOL and Technet but do not see anything that resembles the MoveGroup command used in Cluster Administrator. I found just about every other command including stopping and restarting the cluster, but Move Group is my perferred method.

You help is appreciated and yes I am trying to educate them that this is not the answer but for the present no one is listening to either the consultants or myself.

Raymond Laubert
MCSE, MCDBA, MCITP:Administration, MCT

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-30 : 22:22:31

cluster.exe CLUSTERNAME group "GROUPNAME" /moveto:node_name

To move a group called Disk Group 1 on the OpsClus1 cluster from OpsNode1 to OpsNode2, type:

cluster opsclust group "disk group 1" /moveto:opsnode2

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2008-07-31 : 07:16:29

should this
cluster opsclust group "disk group 1" /moveto:opsnode2
not be
cluster opsclus1 group "disk group 1" /moveto:opsnode2
?

rlaubert
Yak Posting Veteran

96 Posts

Posted - 2008-07-31 : 14:37:37

I have groups called Cluster Group, DTC and SQL. SQL is the main cluster. DB1 and DB2 are the nodes in the cluster.
When I manually failover I choose SQL and Move Group from the menu.
So if I understand this correctly, If I am currently on DB1 as Owner and active node, I would use the following command:

cluster.exe DBCluster group "SQL" /moveto:DB2

Is this correct?

Raymond Laubert
MCSE, MCDBA, MCITP:Administration, MCT

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-31 : 22:49:14

Correct if cluster name is DBCluster.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources