John Mitchell-245523 (7/28/2016)
Build the verification into your backup job, so it's done as soon as the backup is made.By the way, VERIFYONLY only checks the file header. You might want to consider using the WITH CHECKSUM option to give you slightly more confidence. But the only way to be totally sure that you'll be able to restore a backup is to test it. You may not want to test all 110 every week - if that's the case, pick some at random and test them.
Thomas "SQLRockstar" LaRock did an article for Simple-Talk on Statistical Sampling for Verifying Database Backups[/url] - sounds like it could be useful in this situation.
Thomas Rushton
blog: https://thelonedba.wordpress.com