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.