Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to: Stop an Instance of SQL Server (SQL Server Management Studio)

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.

Community Additions

ADD
Show:
© 2015 Microsoft