25 October 2014

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

No comments:

Post a Comment