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.

In This Section

How to: Start an Instance of SQL Server (sqlservr.exe)

How to: Stop an Instance of SQL Server (sqlservr.exe)

See Also

Other Resources

Managing Services Using SQL Server Configuration Manager
Managing Services Using SQL Server Management Studio
Managing Services from the Command Prompt Using net Commands

Help and Information

Getting SQL Server 2005 Assistance