BobSpenc
asked on
how to stop mssql
How can I stop and start Microsoft SQL Server 2005 Express, from the command line?
net stop mssqlserver
you mean the sql service or the client?? please be clear!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, both.
use this:
net stop mssqlserver
net stop mssqlserver
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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