Hi Reddy,

You can use the following commands:

To Stop
1. Net Stop Mssqlserver (Default Instance)
2. Net Stop Mssql$<InstanceName> (Named Instance)

To Start
1. Net Start Mssqlserver (Default Instance)
2. Net Start Mssql$<InstanceName> (Named Instance)

Rohini

----- Original Message -----
From: "Reddy Shiva "
<mssqldba-ezmlmshield-x30650485.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, March 30, 2007 1:08 AM
Subject: shut down and restart


> How to shutdown and restart the sql server 2000 of named instance
> through a batch file. The batch file should accept the parameters.
>
> Thanks & Regards
> Shiva Reddy
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


MS Sql Server LazyDBA home page