Link to home
Start Free TrialLog in
Avatar of BobSpenc
BobSpenc

asked on

how to stop mssql

How can I stop and start Microsoft SQL Server 2005 Express, from the command line?
Avatar of chapmandew
chapmandew
Flag of United States of America image

net stop mssqlserver
you mean the sql service or the client?? please be clear!!
SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BobSpenc
BobSpenc

ASKER

Sorry, both.
use this:

net stop mssqlserver
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
the above will work for full SQL server,  but if you have SQL Express, then you may have to give the "instance" name as part of the command line
NET STOP MSSQL$SQLEXPRESS    (look in services.msc for the service name)
NET STOP MSSQL$BACKUPEXEC    ECT.....
THEN IN REVERSE
NET START MSSQL$instancename
 
-Jim