Managing Services from the Command Prompt Using 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.
In This Section
| Topic | Description |
|---|---|
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. |
Gives detailed instructions on how to stop SQL Server using the net commands. |
|
Gives detailed instructions on how to start SQL Server Agent using the net commands. |
|
Gives detailed instructions on how to stop SQL Server Agent using the net commands. |
See Also
Other Resources
Managing Services Using SQL Server Configuration Manager
Managing Services Using SQL Server Management Studio
Managing SQL Server from the Command Prompt Using sqlservr.exe