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
net start MSSQLSERVER /f /m
net start MSSQL$CUSTDATAWAREHOUS /f /m
 
No comments:
Post a Comment