SQL Server Performance Forum – Threads Archive
Clustering and Fail-Over.Has onyone found a way to failover a server using the command prompt, or some other meands with a task to force a restart of the server. We are trying to come up with a schedule for restarting clustered servers, and want to fail over the cluster without having to manually sit in front of the box and do it, ie<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />chedule a task from within windows. I know we cannot do this from SQL, that it would have to be done at the OS levell.<br /><br />-David<br /><br /><br /><br /><br />-David Roesch<br />San Diego, Ca
Have you looked at AT command in Windows and scheduler to perform such command line operations. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Hi ya, which OS are we talking about? on windows 2003 there is the cluster command cluster group <GroupName> /move Cheers
Sorry for the delay all this xmas shopping got me behind. <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /> We are using Windows 2003 OS. I will check on that command, and see what I can find, appreciate it…<br />-David<br /><br /><br />-David Roesch<br />San Diego, Ca