I was doing some investigation on how other DBAs go about performing automated regular tests of their database backups to ensure recoverability in case of disaster and I'm quite disappointed at what sparse topics I found on the topic.
I'll try to describe the solution that I came up with for my company in the comments, but how do you guys ensure that your backups are actually recoverable?
- Do you recover your backups to test servers on regular basis? Using scripts?
- Third-party software with this capability?
- Running verify-only on the backups?
- Letting your junior DBA do recovery tests?
Let me know if I should rephrase or add anything to the question.
After some time and polishing, i decided to publish my script if anyone's interested. https://github.com/curiebabz/SSARS