Export (0) Print
Expand All

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.

ms190681.note(en-US,SQL.90).gifNote:
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.

  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.

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

Community Additions

ADD
Show:
© 2014 Microsoft