How to pause and resume the default instance of SQL Server (Command Prompt)

To pause and resume the default instance of SQL Server

• From a command prompt, enter either:

  net pause mssqlserver

  -or-

  net continue mssqlserver

  An instance of Microsoft® SQL Server™ can be paused or resumed only if it was started as a Microsoft Windows NT® 4.0 or Windows® 2000 service.

See Also

Pausing and Resuming SQL Server