What's the best way to start and stop SQL Server from the command line?

Question

I need to start and stop SQL Server from the command line. I am willing to write a small C# program if necessary, but I suspect that there's something (PowerShell, maybe?) that currently exists that does this gracefully.

Thank you.

Answer 1

net {start|stop} mssqlserver

Answer 2

net start/stop

http://technet.microsoft.com/en-us/library/cc736564.aspx

Answer 3

Or, in PowerShell, Stop-Service, Start-Service, or Restart-Service. Note that all of this has to be done on a per-instance basis, just as with the other suggestions here.

Answer 4

http://msdn.microsoft.com/en-us/library/ms187463.aspx

Answer 5

Here's an answer that actually contains a little bonus information...and more thoroughly answers the question. What if you have more than one instance of SQL server? Then you need to know the extended syntax of NET START. You can start services by Name, not just by service moniker (or whatever mssqlserver is an example of):

NET START "sql server (instancename)"

This applies to other services, too. Want to start the System Event Notification Service?

NET START "System Event Notification Service"

Boom goes the dynamite! hehe

Answer 6

For restarting SQL Server and SQL Server Agent you can create a batch file called restartsql.bat with the following commands in it, save it, and run it when needed:

@ECHO OFF net stop "SQL Server Agent (MSSQLSERVER)" net stop MSSQLSERVER net start MSSQLSERVER net start "SQL Server Agent (MSSQLSERVER)"

Enjoy!

Answer 7

With the commands below, I could start and stop SQL Server 2019 Express:

net start "SQL Server (SQLEXPRESS)"

net stop "SQL Server (SQLEXPRESS)"

You can find the actual name of SQL Server on SQL Server Configuration Manager as shown below:

And, this is How to find and open SQL Server Configuration Manager.