Sunday 27 April 2014

Manage SQL Server Services from the Command Line

You can start and stop Sql Services by cmd by following commands:-


NET START MSSQLSERVER:-
 Starts SQL Server as a service. 

NET STOP MSSQLSERVER :-
Stops SQL Server when running as a service. 

NET PAUSE MSSQLSERVER:-
 Pauses SQL Server when running as a service. 

NET CONTINUE MSSQLSERVER:-
 Resumes SQL Server when running as a service.

To manage named instances of SQL Server, use the following commands: 

NET START MSSQL$instancename :-
Starts SQL Server as a service, where instancename is the actual name of the database server instance. 

NET STOP MSSQL$instancename:-
 Stops SQL Server when running as a service, where instancename is the actual name of the database server instance. 

NET PAUSE MSSQL$instancename :-
Pauses SQL Server when running as a service, where instancename is the actual name of the database server instance. 

NET CONTINUE MSSQL$instancename:-
 Resumes SQL Server when running as a service, where instancename is the actual name of the database server instance.


You can add startup options to the end of net start MSSQLSERVER or net start MSSQL$instancename commands. Use a slash (/) instead of a hyphen (–) as shown in these examples: 
net start MSSQLSERVER /f /m
 
net start MSSQL$CUSTDATAWAREHOUS /f /m

No comments:

Post a Comment