Centralised Backup Reporting

• Colin Smith

  SSC Enthusiast

  Points: 195

  More actions

  June 6, 2013 at 2:49 am

  #278681

  Hi All,

  I work with an environment where we have hundreds of Server’s, many with common user databases, others with uncommon databases and checking that database maintenance, in particular database backups are taking place, is becoming quite a challenge. We have our own in-house alerting system that alerts us to jobs that have failed, which we can view on a centralised monitoring system, but, what we’re really after is something centralised, that will report what databases have not been backed up for x amount of days, with the aim of highlighting backup jobs that may have been disabled or simply don’t exist. I’ve looked at Idera’s Backup Status, which is contained within its SQL Admin Toolset, and it’s close to the mark, but, unfortunately you can’t filter out specific user databases that aren’t backed up on purpose and in our case, we have a number of databases that are the same, on all servers and thus we don’t back them up as we can always get copy of the database from another server. Hopefully I’ve explained the situation well, any suggestions would be appreciated.

  Thanks, Col