June 6, 2013 at 2:49 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy