Auto Close and why you want it OFF

So I was perusing my SQL Server Error Logs on my web server and found all my databases restarting. 



All night. 



Every 2 seconds.  



It turns out that the reason for this is that the database is set to automatically shut down whenever there are no more connections.  In a web environment, that means every single time there is a page hit.



We need to turn this off.  Now.



Open SQL Server Management Studio and log in.

From the Object Explorer select

• Server




• Databases




• DatabaseName → Properties

Make sure Auto Close is set to False.





...

---

Bryan Valencia is a contributing editor and founder of Visual Studio Journey.  He owns and operates Software Services, a web design and hosting company in Manteca, California.