Log Backup recommendation

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Log Backup recommendation

Postby eilandd » Tue Aug 03, 2010 2:08 pm

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
Posts: 31
Joined: Mon Mar 19, 2007 3:36 pm

Postby priyasinha » Wed Aug 04, 2010 1:52 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: 549
Joined: Wed Jan 03, 2007 4:02 pm

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests