How to: Pause and Resume an Instance of SQL Server (net Commands)
This documentation is archived and is not being maintained.

How to: Pause and Resume an Instance of SQL Server (net Commands)

The Microsoft SQL Server service can be paused and resumed using Microsoft Windows net commands.

  1. From a command prompt, enter the following command:

    net pause "SQL Server (MSSQLSERVER)"

  1. From a command prompt, enter one of the following commands. Replace instancename with the name of the instance you want to manage.

    net pause "SQL Server ( instancename )"

    -or-

    net pause MSSQL$ instancename

  1. From a command prompt, enter the following command:

    net continue MSSQLSERVER

  1. From a command prompt, enter one of the following commands. Replace instancename with the name of the instance you want to manage.

    net continue "SQL Server (instancename)"

    -or-

    net continue MSSQL$ instancename

    ms189250.note(en-US,SQL.90).gifNote:
    An instance of SQL Server started from the command line or with startup options cannot be paused or resumed unless it was started as a Windows service.

Show:
© 2016 Microsoft