Different ways to start and stop DB Services

Share us

There are many ways to start and stop DB services in SQL Server. Here I am writing down most frequently used in real time by DBA.      

  1. Using SQL Server Configuration Manager                                                                                Go to SQL Server Configuration Manager -> Yes->Go to Services->Select the services you want to stop. For DB services we used to stop SQL Server(MSSQLSERVER). It gives a prompt like you also want to stop Agent, we click yes.Config_ManagerConfig_Stop
  2.  Using Windows services

Open services using services.msc. It will look like below screenshot. Type SQL and all services related to SQL will come. We then stop the DB services.

Stop

3.    Using Object explorer in SSMS

From GUI also, we can stop and start the DB services.

Updated_1

4.  Using the Net start command

Apart from above mentioned methods, we can also use the                 Net Start command. Just type net start mssqlserver at the                   command prompt. To start a named instance, we have to type            net start MSSQL$instancename. In below screenshot, we have            started default instance.

Netcommand                 To stop the services, we need to write stop in place of start.

 

Feel free to share your view, comments.

 

 

 

One Commentto Different ways to start and stop DB Services

  1. Jaymie Leeds says:

    It is perfect time to make some plans for the future and it’s time to be happy. I have read this post and if I could I desire to suggest you few interesting things or suggestions. Maybe you can write next articles referring to this article. I wish to read more things about it!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.