Tag Archives: proper shutdown of sql server

Gracefully shutdown SQL Server, stop accepting new connections

During maintenance activity we try to bring down SQL server gracefully without impacting existing transactions and not accepting new connections. One of the best options to accomplish this is to PAUSE SQL Service using SQL Server configuration Manager. Pausing SQL … Continue reading

Posted in Productivity, SQL | Tagged , , , , , | Leave a comment