Export (0) Print
Expand All

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.

Community Additions

ADD
Show:
© 2014 Microsoft