dbTalk Databases Forums  

Automating a Cluster Group Failover

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Automating a Cluster Group Failover in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tom
 
Posts: n/a

Default Automating a Cluster Group Failover - 02-19-2010 , 06:38 AM






Is anyone aware of a utility or a script that is available that would allow
an automated failover of a SQL Server Virtual Cluster Resource Group to
another node in the cluster?

Would like to call it out remotely via a scheduler process or SQL Agent..

thanks

Reply With Quote
  #2  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: Automating a Cluster Group Failover - 02-19-2010 , 08:14 PM






"tom" <frosty (AT) nospam (DOT) nospam> wrote

Quote:
Is anyone aware of a utility or a script that is available that would
allow
an automated failover of a SQL Server Virtual Cluster Resource Group to
another node in the cluster?

Would like to call it out remotely via a scheduler process or SQL Agent..
What version of the OS?

cluster.exe will work for you in most cases, and you can script it and then
run it via the task scheduler

Reply With Quote
  #3  
Old   
Charles Wang [MSFT]
 
Posts: n/a

Default RE: Automating a Cluster Group Failover - 02-22-2010 , 02:41 AM



Hi Tom,
You can use the command "cluster group <groupname> /move" or equivallent
Powershell script to remotely failover your cluster. Here are some articles
for your references:
Appendix A - Cluster.exe Commands
http://technet.microsoft.com/en-us/l.../cc723245.aspx
Mapping Cluster.exe Commands to Windows PowerShell Cmdlets for Failover
Clusters
http://technet.microsoft.com/en-us/l...44(WS.10).aspx

Best regards,
Charles Wang

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.