Friday, January 7, 2011

MSSQL & Event ID: 17137

In Event Viewer > Application, If you have noticed Thousands of Events with details "Starting up database.." Event ID: 17137, here is the solution :

Make sure to set all the database in your SQL Server as Auto_Close=False. By default in SQL Server Express Editions, Auto_Close was set to True. If Auto_Close is true, SQL Server close the DB when the last connection is closed. So the databases were stopped & started regularly.

To Set Auto_Close = False
In SQL Server Manager > Right Click Database > Properties > Options, you can find the option.
OR
ALTER DATABASE SET AUTO_CLOSE OFF