How to: Stop an Instance of SQL Server (SQL Server Management Studio)

Microsoft SQL Server can be stopped and started from SQL Server Management Studio.

Note

To ensure an orderly shutdown, you should pause SQL Server and stop SQL Server Agent before stopping an instance of SQL Server. You can stop both SQL Server and SQL Server Agent by using either SQL Server Configuration Manager or SQL Server Management Studio.

To stop an instance of SQL Server

  1. In Registered Servers or Object Explorer, right-click the server instance you want to stop, and then click Stop.

    A message box asks whether you are sure you want to stop MSSQLSERVER on the server instance you chose.

  2. Click Yes.

    A red square on the icon next to the server name indicates that the server stopped successfully.

To stop a clustered instance of SQL Server

  1. Microsoft running on a cluster is best managed with Cluster Administrator. For more information, see Using SQL Server Tools with Failover Clustering.

See Also

Tasks

How to: Broadcast a Shutdown Message (Command Prompt)
How to: Stop an Instance of SQL Server (SQL Server Configuration Manager)
How to: Stop an Instance of SQL Server (net Commands)
How to: Start an Instance of SQL Server (SQL Server Management Studio)
How to: Pause and Resume an Instance of SQL Server (SQL Server Management Studio)
How to: Configure WMI to Show Server Status in SQL Server Tools

Concepts

Stopping Services

Help and Information

Getting SQL Server 2005 Assistance