How to Shutdown SQL Server without interrupting existing users.

Is there a way to shutdown SQL server without interrupting to existing users? Yes you can
I am sure you have opened Window Services or SQL Server configuration manager many times before. Have you ever notice that when you right click on the SQL Server it gives you 5 options. One of this options does the trick for you. 

Option that does the trick is ‘Pause“.

Once you pause the service it will NOT allow for any new connections to be made with SQL service; however it will allow existing users to do their work until they cut off the connection with the SQL Service.  
Once all the users are logged off from the service you can safely shutdown your SQL Server. 

Thank you and Regards,
Tharanga Chandrasekara

Click on a star to rate it!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Leave a Reply

Your email address will not be published.

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