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.
See Also
Tasks
How to: Pause and Resume an Instance of SQL Server (SQL Server Configuration Manager)
How to: Pause and Resume an Instance of SQL Server (net Commands)