Toad World® Forums

Exclude offline databases from days since last backup list

Hi, is it possible to exclude offline databases from the “Days Since Last Full Backup” alert list? We take databases offline for a time prior to deleteing. I have not been able to take advantage of this alarm because of the offline databases in the list.

Thanks,

Howard

Howard,

Yes, we can do that. We have an existing enhancement request that requires us to modify the script that drives this alarm to ignore read-only databases so I have updated that to add that the script should also ignore offline databases as well. It is a relatively simple change so we could supply a patch for you if you would like that. Please raise a case with support if you would like a patch for this problem.

Rob Griffin

Software Analyst, Spotlight on SQL Server

Dell Software R & D