April 25, 2008 at 11:21 am
I need to find out where the difference is between the error log and a script that runs
I run the following command
sp_readerrorlog 0, 1,'CHECKDB'
I am interested in the DWAnalytics database
LogDateProcessInfoText
2008-04-22 09:21:55.370spid26sCHECKDB for database 'DWAnalytics' finished without errors on 2007-09-25 18:43:05.740 (local time). This is an informational message only; no user action is required.
I ran this script
http://www.sqlservercentral.com/scripts/Administration/62598/
I see the following for DWAnalytics
DatabaseNameLastGoodCheckDBDaysSinceGoodCheckDBHoursSinceGoodCheckDB
DWAnalytics2007-09-25 18:43:05.7402135106
Why would there be date difference?
What do I need to look at?
April 25, 2008 at 1:14 pm
what's correct is that there are no errors found when you run checkdb, not dates.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
April 25, 2008 at 5:48 pm
I agree with Colin. The tools might have bugs that don't necessarily update all dates. I know I've seen issues with product versions being off between the 3 or 4 places they're stored.
Worry about this if you get errors.
April 25, 2008 at 6:22 pm
Thank you
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply