Pausing and Resuming Services

When you pause an instance of Microsoft SQL Server, users that are connected to the server can finish tasks, but new connections are not allowed. For example, you can pause an instance of 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.