Boring post, boring is the goal. Everyone says "test your restores". Here is a drill small enough that you will actually do it every month.
- Pick one backup at random, not the latest and not the one you know is good.
- Restore it to a scratch location on a different machine than the one that made it. If it only restores on the original host, you tested very little.
- Check three things: - it finished without errors, - file counts and total size match what you expect, - open the three files you would miss most and look at them with your eyes.
- Write down the time it took. That is your real recovery time, and it is always longer than the number in the plan.
- Delete the scratch copy.
What it usually finds, in my experience:
- The encryption key is on the machine that died.
- The restore needs a tool version that is no longer installed.
- A directory nobody remembered to include.
- It works, takes nine hours, and the plan said two.
Each of those is a bug you want to meet on a calm afternoon, not on the worst day. Put it in a calendar and make it somebody's job.