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.
