Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

To pause the default instance of SQL Server

  • From a command prompt, enter the following command:

    net pause "SQL Server (MSSQLSERVER)"

To pause a named instance of SQL Server

  • 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

To resume a paused default instance of SQL Server

  • From a command prompt, enter the following command:

    net continue MSSQLSERVER

To resume a paused named instance of SQL Server

  • 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

    NoteNote

    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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.