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.

NoteNote

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft