Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mr_mist
Grunnio
1870 Posts |
 Posted - 2004-05-27 : 10:46:15
|
| Can anyone tell me (where I can find) the method by which I can script (in dos) the stopping / restarting of a SQL instance that is part of a cluster?-------Moo. :) |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-05-27 : 10:57:43
|
| NET STOP mssql$instancenameNET START mssql$instancename |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-05-27 : 12:26:55
|
| Will this prevent the clustered instance from failing over?-------Moo. :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-27 : 14:27:23
|
| You should not be stopping the clustered services using NET STOP or starting them using NET START. They should be done in the Cluster Administrator. If you don't want them to fail over to the other node, perform a Take Offline. I have not seen anything scripted from Cluster Administrator.Tara |
|
|
|
surefooted
Posting Yak Master
188 Posts |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-05-27 : 14:53:15
|
| I'm with Tara on this one. When working with clustered resources ALWAYS manipulate them through Cluster Administrator. Net Stop might work, but I bet that it fails over to the other node.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
gercr
Yak Posting Veteran
53 Posts |
Posted - 2004-05-27 : 17:10:28
|
| I use this command:cluster /CLUSTER:<CLS NAME> RES "<SERVICE NAME>" /OFFIn fact we use a full menu commands scriptthe cluster.exe is on your server machine and with /? you get all the help yo need.Regards.Gerardo G. |
|
|
|
|
|
|
Stopping a clustered sql server