หมายเหตุ
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลอง ลงชื่อเข้าใช้หรือเปลี่ยนไดเรกทอรีได้
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลองเปลี่ยนไดเรกทอรีได้
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
Note
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.
See Also
Tasks
How to: Pause and Resume an Instance of SQL Server (SQL Server Configuration Manager)
How to: Pause and Resume an Instance of SQL Server (SQL Server Management Studio)
How to: Start an Instance of SQL Server (net Commands)
How to: Stop an Instance of SQL Server (net Commands)