We all know how important to check (and restore) your backup file is, right? ;-) ... so I am trying to follow that good practice without making it an impossible task. (I have hundreds of databases assigned to me, space and time is limited)
So my question would be, or more kind of a poll question, what schedule do you use? Here's what I am trying to implement.
-Weekly check (Sundays): critical clients or anything above 100GB
-Monthly check(Sundays): anything lower than 100GB or any other client.
I am using RedGate 7.0 which allows me, as part as the regular check, do the following:
-Grab backup file from backup repository using Scheduled Restore feature
-Delete if everything went fine
-Send email informing
For the Weekly checks, I was planning to start those at 2am, 4am, 6am, and so on. Now, the Monthly checks is what confuses me. I was planning to do that randomly, but how should I schedule those?
By the way, the SQL instance I am using is not a production box. So does not running anything critical. However, I prefer to restore and check weekends, so it will not make it too slow (it's a VMware machine)
Any suggestion is highly appreciated