Export (0) Print
Expand All

Managing Services from the Command Prompt How-to Topics (net Commands)

The Database Engine and SQL Server Agent run as services. You can start, pause, and stop the services with SQL Server Configuration Manager. From the command prompt you can also start, pause, and stop the Database Engine service using the net commands (net start, net pause, and net stop, respectively). You can also manage the service using the sqlservr.exe program, but typically the sqlservr.exe program is only used for troubleshooting or major maintenance. For more information about services, see Managing the Database Engine Services.

This section covers the following topics related to managing the services from the command prompt by using the net commands.

How to: Start an Instance of SQL Server (net Commands)

Gives detailed instructions on how to start SQL Server using the net commands.

How to: Pause and Resume an Instance of SQL Server (net Commands)

Gives detailed instructions on how to pause and resume SQL Server using the net commands.

How to: Stop an Instance of SQL Server (net Commands)

Gives detailed instructions on how to stop SQL Server using the net commands.

How to: Start SQL Server Agent (net Commands)

Gives detailed instructions on how to start SQL Server Agent using the net commands.

How to: Stop SQL Server Agent (net Commands)

Gives detailed instructions on how to stop SQL Server Agent using the net commands.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft