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

How to Install SQL Server 2000

How To

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