How to start and stop the SQL Server service from command line

Here are a couple ways to stop and start the SQL Server service from a command line:

Option 1: use the NET START and NET STOP commands:

?View Code VBNET START MSSQLSERVER

and

?View Code VBNET STOP MSSQLSERVER

If you have a named instance, you will have to replace the ‘MSSQLSERVER’ with the proper service name, for example MSSQL$SQL2008 .

!!!

Continue reading […] How to start and stop the SQL Server service from command line […]