• First to post!!! /self promote with no good content timseedorf.com

    Our environment has many SQL servers and we use a few third party backup tools. On a few environments, I manage local backups of SQL but those are typically for dev purposes. We use Avamar for backups in our EMC environment which hosts Relativity by kCura and then we use Appassure for SQL backups and other backups. I am not responsible for making sure the backups work necessarily and especially not performing them. We have a person responsible for that...he gets me the data I need and I restore or attach, etc...

    So if a disaster happen, I have to hope he is doing his job. Rather than hope though, I do monitor that the backups are working and and resolve errors with him. I do not test them, however, Appasure automatically tries to mount the backup to make sure it's good.

    So, we've got a two man process as it relates to backups. However, by utilizing third party backup software we can restore to every hour AND we can check the backups for mount-ability at once.