Pulling out Backup Failure information
I have searched around and I cant find a satisfactory response to my question so figured I would ask it here. I know that there is a Reporting function within the SQL Backup GUI for pulling out failed backups however it is not giving me enough information and I cannot easily monitor it externally.
Is there a better way of identifying failed backups and pulling out what backup and what type of backup operation, when and why a backup operation failed? In the past this was a pain to report on as I would have to check for return codes for backup tasks which means the best I could get is that a backup job failed, this job would cover multiple databases and then require manually looking in the tool to ascertain what went wrong. Not particularly slick. Is there a better way?