Export (0) Print
Expand All
Expand Minimize

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

SQL Server 2000

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

Note  Before stopping an instance of 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, and 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, and then click Stop.

  4. Right-click the server, and then click Stop.

Note  Stopping an instance of SQL Server by 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.

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

  1. If the service is a remote service, in the Server box, enter the name of the remote server. If it is a local server, the Server box will be filled in.

    This connects you to the remote server and populates the Services box with the names of the SQL Server services registered on the remote computer.

  2. In the Services dialog box, click SQL Server or SQL Server Agent.

  3. Click Pause.

If you are stopping SQL Server Agent, proceed to Step 4. Otherwise, send a message informing connected users that the server will be shutting down. After an appropriate interval, proceed to Step 4.

  1. Click Stop.

See Also

Stopping SQL Server

Show:
© 2015 Microsoft