You can use the NET STOP and NET START commands from the command-prompt to
stop/start any Windows service. For a default SQL Server instance:
NET STOP MSSQLSERVER
NET START MSSQLSERVER
For a named instance:
NET STOP MSSQL$MyInstance
NET START MSSQL$MyInstance
You can also use SQL-DMO to stop/start a SQL Server instance. VbScript
Examples:
'stop example
Option Explicit
Dim oSQLServer
Set oSQLServer = CreateObject("SQLDMO.SQLServer")
oSQLServer.Name = "MyServer"
oSQLServer.Stop
'start example
Option Explicit
Dim oSQLServer
Set oSQLServer = CreateObject("SQLDMO.SQLServer")
oSQLServer.Start False, "MyServer"
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul O. Morris" <po******@comcast.net> wrote in message
news:K8********************@comcast.com...
Is there a script that I can run to stop a particular SQL server service
on Win2003 server? I'm looking for a similar script to restart that
service as well. Thanks.