February 19, 2010 at 5:47 am
Has anyone come across a method where a SQL resource group can be automated to failover to the passive cluster node through a scheduler or SQL Agent?
We host multiple instances on nodes and would like the capability to select one of the Virtual SQL resource groups and fail it over to an alternate node.
Thanks
February 19, 2010 at 7:03 am
Check out %SystemRoot%\Cluster\CluAdmin.exe
it has a command line version ...
Topic "Managing a server cluster from the command line" at Technet:
http://technet.microsoft.com/en-us/library/cc779044%28WS.10%29.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 5, 2010 at 12:09 am
restart the active node using xp_cmdshell 😀
March 5, 2010 at 1:24 am
Stopping the cluster service on the active node is probably as gentle a method as you will find. You can do that via the cluster node /stop command or a plain old net stop <service> command.
March 5, 2010 at 6:58 am
Thanks all for the tips and responses...Worked like a charm..
March 7, 2010 at 4:55 am
just curious ... can you share which solution you implemented ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply