How to stop and start the sql server services.

we have 4 ways to stop and start the sql server services.
1) services.msc
2) Management studio
3) Command prompt
4) Configuration Manager

Services.msc:
  with help of following steps we can stop and stat the sql server services.
1) Go to run

2) Type services.msc and press enter.
3) select the sql database engine services and then right click on service.

4) click on the stop button.

Note : The sql agent is dependent on the sql database engine services. so, when we stop the sql database engine services the agent services stop automatically. But when you start the sql database engine service the agent service doesn't start automatically. we need to start the agent services manually.
Start the sql server services:
1) 1) Go to run

2) Type services.msc and press enter.
3) select the sql database engine services and then right click on service.
4) press on the start button.

5) select the sql agent service and right click on the service.
6) press on the start button.

Through Management studio:
 with help of the following steps we can stop and start the sql services through Management studio.
1) Open the Management studio.
2) Connect to the sql instance, which we want to stop.
3) right click on the instance name and select the stop button.

Note: Once we closed the Management studio after stop the sql server services, it is not possible to start the sql server services through Management studio. we need to follow the other process to strat the sql server services.
Command Prompt :
1) Open the run and type cmd and press ok button.
2) type below command on cmd and press enter.
net stop mssqlserver --- ( for default instance)
net stop mssql$instancename ---- ( for named instance )

3) type the below command for start the sql server service.
net start mssqlserver ---- ( for default instance )
net start mssql$instancename ---- ( for named instance )

Configuration Manager :
1) Go to start and select all programs and then select Microsoft sql server under this one select the configuration tools and then select the sql server configuration manager.

2) select sql server service on left side panel like on above screen shot. and then select the sql server instance name which you want to stop the services. and right click and select stop button to stop the sql database engine services.

3) same process to start the sql server services.

Note: Please post your comments...

Happy Learning