Red Gate forums :: View topic - integrity due alert
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

integrity due alert

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
xdai



Joined: 31 Dec 2008
Posts: 69

PostPosted: Tue Jan 29, 2013 4:49 pm    Post subject: integrity due alert Reply with quote

Hi,

I am wondering why we get alerts on integrity due on msdb and model db, when dbi_dbccLastKnownGood date field is greater than the 7 days we specify? For example, we have the job start at 2 am, and the model and msdb dbi_dbccLastKnownGood is 02:01:55.707, but we got alert. However, the master db dbi_dbccLastKnownGood field is 05:00:11.323 (all three databases run integrity check at the same job), but the job finish in less than an hour about 3 am. So why master's dbi_dbccLastKnownGood is 05:00:11.323? How does this field get updated?

thanks
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 308
Location: Cambridge, UK

PostPosted: Wed Jan 30, 2013 9:16 pm    Post subject: Reply with quote

The alert is generated based on the content of the dbi_dbccLastKnownGood at the time that it checks it (SQL Monitor has a complex polling schedule). This value is populated and maintained by SQL Server itself, SQL Monitor only reads it.

However, I am not sure what you are asking. Are you experiencing an error?
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
xdai



Joined: 31 Dec 2008
Posts: 69

PostPosted: Wed Jan 30, 2013 9:21 pm    Post subject: Reply with quote

Yes. the integrity check job start at 2am, and the model and msdb dbi_dbccLastKnownGood field both are 02:01:55.707, and the job completed successfully. but why we still got alert about the due for model and msdb?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group