Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Reboot Task of Clustered Nodes

Answered Reboot Task of Clustered Nodes

  • Monday, August 30, 2010 1:08 PM
     
     
    Sign In to Vote
    0

    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?

     

    Thanks

     

All Replies

  • Monday, August 30, 2010 2:19 PM
     
     
    Sign In to Vote
    0
    Cluster.exe provides you with many options.


    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
     
  • Thursday, September 09, 2010 4:03 PM
     
     
    Sign In to Vote
    0

    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.

     

    Thanks

     
  • Tuesday, September 14, 2010 8:52 AM
     
     Answered
    Sign In to Vote
    0

    Hi Taylor,

    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.

    http://groups.google.com/group/microsoft.public.scripting.vbscript/browse_thread/thread/fd826a8a9b2b17f0

     

    Regards Gursethi Blog: http://ms-gursethi.blogspot.com/