Hi all,

Need u guys help again. I have 2 nodes running sql in the company. My
question is there any way that i could create a script such that the
primary node will failover to the secondary node at a certain day and time
that i specified in the scripts so that i can do maintenance on the primary
node.

Do u guys have any scripts that can do that?

Appreciate u guys input. U guys have been helpful.

Tks

Mohd

--
Message posted via http://www.sqlmonster.com

Mohd

Yes you can use cluster.exe utility to perform that operation. You would
just have to schedule the task to run at a certain time

cluster.exe <clustername> group "my group name" /moveto:<node name>

For example if I was moving my SQL Group to Node2, with the

cluster name MSCS the command would be:

cluster.exe MSCS group "Sql Group" /moveto:Node2

You would create a line like above for each group in your cluster

Regards

CT


"Mohd via SQLMonster.com" wrote: