How to stop the default instance of SQL Server (Command Prompt)

To stop the default instance of SQL Server

• From a command prompt, enter:

  net stop mssqlserver

Note  Stopping a default instance of Microsoft® SQL Server™ using SQL Server Enterprise Manager or the net stop mssqlserver command causes SQL Server to perform a checkpoint in all databases. Then a SHUTDOWN WITH NOWAIT is done to flush all committed data from the data cache and to stop the server immediately. Stopping a default instance of SQL Server from the command prompt works only if you are running Microsoft Windows NT® 4.0 or Windows® 2000.

See Also

Stopping SQL Server