Pausing and Resuming SQL Server

When you pause Microsoft® SQL Server™, users who are connected to the server can finish tasks, but new connections are not allowed. For example, you can pause SQL Server for a few minutes and send a shutdown message to connected users before shutting it down. You can also resume a SQL Server service.

Note You cannot pause SQL Server if it was started by running sqlservr. Only SQL Server services started as Microsoft Windows NT® services can be paused.

For information about pausing and resuming SQL Server from the Services application in Control Panel, see your Windows NT documentation.

To pause and resume SQL Server