Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Scripting SQL Cluster Shutdown Expand / Collapse
Author
Message
Posted Sunday, November 23, 2008 4:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 16, 2010 9:39 PM
Points: 5, Visits: 27
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?
Post #607234
Posted Monday, November 24, 2008 5:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 2,247, Visits: 2,708
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’! **
Post #607422
Posted Tuesday, November 25, 2008 10:01 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 1:42 AM
Points: 448, Visits: 322

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 :)


-Hope is a heuristic search ~Hemanth
Post #608840
Posted Sunday, November 30, 2008 6:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 16, 2010 9:39 PM
Points: 5, Visits: 27
Thanks, all very helpful! :D
Post #610986
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse