Posted by Paul O. Morris on 07/06/05 05:37

Would the syntax be the same if I ran the command line script from within a
batch file?

I'm planning on running this batch file from within the BackUp Exec
software. I have two database programs that run SQL services, preventing
the backup jobs from doing a thorough job. Automatically shutting down
those SQL services will allow jobs to complete properly.


"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:Blyxe.3037$cb6.823@newssvr30.news.prodigy.com...
> 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" <pomorris@comcast.net> wrote in message
> news:K8GdnQw9easBP1vfRVn-gg@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.
>>
>>
>
>

[Back to original message]