Scripting SQL Cluster Shutdown

• richard.shutt

  SSC Journeyman

  Points: 93

  More actions

  November 23, 2008 at 4:13 pm

  #126065

  We are planning a shutdown of a number of clustered SQL Servers and I am trying to develop some VBScript to automate this process. The steps I am trying to develop script for are:

  1) Move everything to Node 1

  2) Set startup to manual

  3) Shutdown Node 1

  4) Shutdown Node 2

  Does anyone know of any existing scripts that would assist in this process?

• HanShi

  SSC-Dedicated

  Points: 33507

  More actions

  November 24, 2008 at 5:02 am

  #902369

  Maybe you can find something on http://www.microsoft.com/technet/scriptcenter/default.mspx

  SQL: http://www.microsoft.com/technet/scriptcenter/scripts/sql/default.mspx?mfr=true

  Cluster: http://www.microsoft.com/technet/scriptcenter/scripts/ccs/default.mspx?mfr=true

  Else I suggest you ask this on a developers forum.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

• hemanth.damecharla

  SSCommitted

  Points: 1740

  More actions

  November 25, 2008 at 10:01 pm

  #903548

  [font="Verdana"]

  I am not sure about VBScript but, you can use some OS commands to get this done.

  I created a job in SQL Server for this and it works fine.

  This is the exact command I have in the job.

  CLUSTER HomeClust GROUP "GROUP D" /MOVETO:Node1 /WAIT:10

  Here is the link that I referred to create the job:

  http://www.microsoft.com/resources/documentation/windowsnt/4/server/proddocs/en-us/clustsvr/mscsadma.mspx?mfr=true

  Hope this helps :)[/font]

  -Hope is a heuristic search :smooooth: _~Hemanth

• richard.shutt

  SSC Journeyman

  Points: 93

  More actions

  November 30, 2008 at 6:43 pm

  #905340

  Thanks, all very helpful! 😀