Recovery Verification

Hi folks,

When performing database recovery tests, after restoring from backup is complete, what SOPs and tools do you use to sample your database contents and verify the data looks correct? Do you have a list of queries to run? What metadata do you capture and where do you save the test report? Do you use automation? Is it built in-house, off-the-shelf, or open-source?

Thanks, I'm not a DBA but no one else works at my company so any pointers would be appreciated.

-Dolan