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