How to stop SQL Server or SQL Server Agent (Enterprise Manager)

Note Before stopping Microsoft® SQL Server™, you should pause SQL Server and stop SQL Server Agent to ensure the most orderly shutdown. You can stop both by using SQL Server Service Manager.

To stop SQL Server or SQL Server Agent (Enterprise Manager)

  1. Right-click a server; then click Pause.
  2. Optionally, send a message informing connected users that the server will be shutting down. After an appropriate interval, proceed to Step 3.
  3. Right-click SQL Server Agent; then click Stop.
  4. Right-click the server; then click Stop.

Note Stopping SQL Server by using SQL Server Enterprise Manager or the net stop mssqlserver command causes SQL Server to perform a checkpoint in all databases and then a SHUTDOWN WITH NOWAIT to flush all committed data from data cache and stop the server immediately.

To stop SQL Server or SQL Server Agent (Service Manager)

  1. In the Server dialog box, specify the name of the remote server
  2. In the Services dialog box, click MSSQLServer or SQLServerAgent.
  3. Double-click Pause.
  4. Send a message informing connected users that the server will be shutting down. After an appropriate interval, proceed to Step 5.

    If you are stopping SQL Server Agent, skip this step and proceed to Step 5.

  5. Double-click Stop.
See Also

Stopping SQL Server


(c) 1988-98 Microsoft Corporation. All Rights Reserved.