April 25, 2007 at 1:22 pm
I am running several SQL 2005 instances. When comparing the ERRORLOG of several different instances, I noticed that one instance's ERRORLOG contains messages similiar to the following when SQL Server is starting up and a new ERRORLOG is created.
"CHECKDB for database 'msdb' finished without errors on 2007-04-19 00:00:05.317 (local time). This is an informational message only; no user action is required."
To test, I ran a CHECKDB on my LiteSpeedLocal database at 2007-04-25 08:45:50.93. I then restarted the SQL Server Service and reviewed the newly created ERRORLOG. The ERRORLOG contained the following line:
"2007-04-25 08:47:33.62 spid15s CHECKDB for database 'LiteSpeedLocal' finished without errors on 2007-04-25 08:45:50.633 (local time). This is an informational message only; no user action is required."
The log entry's timestamp is 2007-04-25 08:47:33.62, but it references the CHECKDB that was ran at 2007-04-25 08:45:50.93.
I was curious if anyone had an idea as to why these CHECKDB informational messages were showing up in the ERRORLOG.
April 27, 2007 at 3:49 am
This is an informational message only. It indicates the last time when the checkdb was run and came out clean.
I have seen this message when the database is going through recovery process.
HTH
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply