Starting Up Database Error in SQL 2008
After installing SQL 2008 SP3 I started getting hundreds of these event log entries.
Event ID: 17137
Description: Starting up database ‘AdventureWorks2008’.
This is due to the AUTO_CLOSE option being turned on. To read more about that setting have a look at the link below. Long story short…you don’t want it on.
To fix the issue open SQL Server Management Studio. Right click the database that is being logged in the error & select Properties. Select Options. Set Auto Close to False. Click OK. No more error. Repeat as needed for other databases.