Monitor, diagnose and receive alerts to problems across your SQL Servers.
Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A
We have a database that was created with full recovery mode but should have been in simple mode. The error was discovered when SQL Response recommended a log backup. We have corrected the recovery mode but the recommendation did not clear. After a full day we disabled the recommendation. After several days it has still not cleared. Short of taking a log backup is there anyway to clear this item? This is a SQL 2005 database and we are running SQL Response 18.104.22.168
- Posts: 31
- Joined: Mon Mar 19, 2007 4:36 pm
Apologies for the issue you are facing.
This looks like a bug with SQL Response. Since the model has now been changed to Simple hence the check has been stopped for this recommendation. I am afraid since recommendation doesn't get purged hence this cannot be removed. We will fix this for V 2.0.
The only workaround I can think of is change the model back to Full. Do a log backup and then wait for this recommendation to go away. Change the model back to Simple again.
- Posts: 532
- Joined: Wed Jan 03, 2007 5:02 pm
Return to SQL Response 1
Who is online
Users browsing this forum: No registered users and 0 guests