• I have an SSIS package that does all this. It chooses ten databases at random from the whole estate and restores them one by one from the latest full, differential and log backups. It then does a DBCC check on each, before putting an F at the start of the name of each database that failed the DBCC, sending out a failure report if appropriate, and deleting all databases that restored and DBCCed successfully. When if finishes, it does the same thing again, excluding any database that's been randomly selected in the last 24 hours.

    John