SQL SERVER Start Stop Restart SQL Server From Command Prompt

Click Start >> Run >> type cmd to start command prompt.

Start default instance of SQL Server
net start mssqlserver

Stop default instance of SQL Server
net stop mssqlserver

Start and Stop default instance of SQL Server.
You can create batch file to execute both the commands together.

You can start, stop, and pause SQL Server as you would any other service. On a local system, you can type the necessary command at a standard command prompt. On a remote system, you can connect to the system remotely and then issue the necessary command. To manage the default database server instance, use these 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: