Home > Computers > Starting Up Database Error in SQL 2008

Starting Up Database Error in SQL 2008

After installing SQL 2008 SP3 I started getting hundreds of these event log entries.

Source: MSSQL$SQLEXPRESS
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.
http://technet.microsoft.com/en-us/library/ms190249.aspx

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.

Advertisements
Categories: Computers Tags: ,
  1. wazab
    February 9, 2012 at 3:59 am

    Thanks a lot. Right to the point.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: