Red Gate forums :: View topic - Stuck recommandation
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

Stuck recommandation

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Tom_NL



Joined: 02 May 2010
Posts: 10

PostPosted: Sun May 02, 2010 8:34 am    Post subject: Stuck recommandation Reply with quote

I just started using SQL Response for a few days nog but i see something i don't understand.

I see 1 database with a recommandation : Integrity Chaeck Overdue
But even after running an DBCC CHECKDB for a few day now, the recomandation stays there.
1 thing i noticed is this recomandation show Last checked : More than a day ago, so it seems this recommandation is not being checked anymore.

i Suspect this condition i caused bij restoring this database about 2 days ago (using SQL backup) while this recomandation was active.
Is there a way to reset this recomandation or another way to het rid of this ?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6643

PostPosted: Mon May 03, 2010 12:40 pm    Post subject: Reply with quote

Hi Tom,

There is nothing in the docs about a restored backup flagging the database for integrity check. It's only flagged up when a check has never been performed or is older than the time that you specify.

The only reasons I have found so far that cause this to fail are that the SQL Server does not have an active licence for SQL Response, the SQL Server ERRORLOG is unavailable, or there is a corrupt SQL Response config file (more than likely an upgrade from a previous version gone bad).
Back to top
View user's profile Send private message
Tom_NL



Joined: 02 May 2010
Posts: 10

PostPosted: Mon May 03, 2010 1:19 pm    Post subject: Reply with quote

Brian,

I don't think, the inegrety check flaged is raiser bij restoring the backup, i just think SQL Response stopped checking this database because of the restore (maybe because the databses has a new db_id after the restore ?).

The integrity check overdue was already flagged before we restored the DB, but it seems it stopped checking this issue as

Last checked : More Then a day ago

I checked the licence activition, and it seems ok, also all recommandations for other databases (about 100) on this server are working fine

SQL errorlog is available normaly

We did not do any upgrade as we just started using SLQ response. Also this server is a fresh installed SQL 2008 on a new Windows 2008R2 sever
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6643

PostPosted: Thu May 13, 2010 1:24 pm    Post subject: Reply with quote

Hi Tom,

It's not that the database ID has changed, as the recommendations are done by database name. Every few minutes, SQL Response checks the SQL Server error log, and if it finds a ^DBCC CHECK(DB|ALLOC) \((.*)\) \w, it updates the DbIntegrityChecks table in the alert repository. SQL Response then checks this table for changes every five hours.

I suppose you could query the alert repository tables using sqlite3. It may be quicker to delete the alert repository files and start over, though, if the problem is corrupt data.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6643

PostPosted: Mon May 17, 2010 2:17 pm    Post subject: Reply with quote

Hi Tom,

By the way, the Alert Repository files are in %allusersprofile%\application data\red gate\SQK Response 1\Alert Repository. Restarting the Alert Repository service. Restarting the Alert Repository Service and clearing everything out will allow you to start over with a clean system.
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