How to Restart the SQL Server Service instance?

To restart the SQL Server Instance , we can do it many ways.

Let's explore the ways.

Using SQL Services:

Click the start button and type services.msc as shown below.

 To  open the services you can also enter the services.msc in Run command as shown below.

 Select the SQL service, right click the service and select the restart option to restart the SQL services as shown below.

After selecting the restart option ,SQL service start to restart as shown below.

 You can also use the below option to restart the SQL service as shown below. (Highlighted in Red Colour).

Now the SQL service Restarted Successfully.

Using SQL Server Management Studio:

Open the SQL server management studio and connect to the SQL server instance which you want to restart.

After connecting the SQL server Instance ,right click the Server and select restart option to restart the SQL service as shown below.

The SQL Server management studio will ask for confirmation to restart the Service and click Yes to restart as shown below.

Now the SQL service Restarted Successfully.

Using Command Prompt:

Run the command Prompt with administrator  and use the Net Start option to start the SQL service and Use Net Stop option to stop the SQL service as shown below.

Replace the "SQL Server <SQLEXPRESS>" with your SQL server instance name as shown below.

After executing the above commands the SQL service will be restarted.

Using SQL Server Configuration Manager:

Open the SQL server configuration manager as shown below.

The SQL server configuration manager will appear and select the SQL server instance which you want to restart.
After selecting the instance , right click the instance and select the restart option as shown below.

The SQL service will be started to restart as shown below.

Finally the SQL service will be restarted.