Frequent Starting Up Database messages in Event Viewer

From WilkWiki
Revision as of 20:21, 26 July 2011 by ChrisW (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Problem

You notice a large number of messages in the Windows Event Viewer Application log in the form Starting up database WilComm or Starting up database WilStore_repository

Autoclose.png

Resolution

These message are a result of SQL Express 2005 setting the AUTO CLOSE=True attribute by default on all databases.

This means that WilComm database is frequently offline and SQL Express must bring it back online whenever it is accessed by WilComm.

Download and install SQL Management Studio Express to set AUTO CLOSE=False on the WilComm database and any WilComm Archive databases.

Autoclose2.png