Frequent Starting Up Database messages in Event Viewer

From WilkWiki
Jump to: navigation, search


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



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.