Managing SQL Server from the Command Prompt Using sqlservr.exe

In most cases, the sqlservr.exe program is used only for troubleshooting or major maintenance. When Microsoft SQL Server is started from the command prompt it behaves slightly differently than when started normally. Carefully review the topics listed below, before running SQL Server in this manner.

This section covers the following topics related to starting and stopping sqlservr.exe from the command prompt.