Monday, August 30, 2010 1:08 PM
I have a SQL Server 2005 in a Active/Passive Cluster. I need to setup a reboot task to handle this for me. Can anyone give me the best practicie for accomplishing this?
Monday, August 30, 2010 2:19 PM
Thursday, September 09, 2010 4:03 PM
Thanks, however cluster.exe does not have what I am looking for. What I am trying to find out is if I create a task to reboot the Windows 2003 Servers once a month what is the best practice since these servers have my SQL Server 2005 Active/Passive Cluster installed on them.
Tuesday, September 14, 2010 8:52 AM
I don't think so there are any best practices document exists on this. Now as you mentioned you want to schedule a monthly task to restart Windows 2003 cluster nodes and its running SQL then what I can say is try to make sure that:
1) First reboot passive node.
2) Move resources to this passive node once it comes online.
3) Reboot this node (from where we moved resources in step 2).
In case you need a script then please go to this link, it has some scripts in this.
Regards Gursethi Blog: http://ms-gursethi.blogspot.com/
- Marked As Answer by Sethu SrinivasanMicrosoft Employee, Moderator Thursday, August 30, 2012 5:34 PM