December 31, 2010 at 7:15 am
Hi, I hope I've posted in the right category.
I have a check database integrity task that runs at 18:00 everyday for ALL databases. My log however is constantly logging an info message for ONE particular database telling me:
-------------------
CHECKDB for database 'databasename' finished without errors on 2010-12-30 18:03:36.947 (local time). This is an informational message only; no user action is required.
Starting up database 'databasename'
-------------------
This message is being logged every 30 secs to 1 minute. The CHECKDB isn't running each time as the finish time is the same on every message.
Appreciate any help. Please let me know if you need anymore info. Thanks.
December 31, 2010 at 7:59 am
Shortly after posting this I've managed to find the answer!
It's at this link if anyone is interested:
December 31, 2010 at 8:03 am
Your database is set to autoclose. That means as soon as the last connection to that DB closes, SQL cleanly shuts the database down. Each time the database is opened, SQL will log that message. Disable autoclose, it shouldn't be enabled for busy databases
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply