Neeraj Dwivedi (5/6/2013)
I do not have any tools, I use batch scripts and SQL jobs to accomplish this. For our most critical applications, I do restore the backups in the Testing environments every week, to check if backups are fine.For every others, I do that automatically to but using windows and SQL job scheduling mechanism, so that I must check every DB in six months.
We send email in case of success & alert in case of failure.
Thanks for reply.
I pretty much know what to do with critical ones, and the schedule I need. But not so sure about frequency for non critical ones.
So, just curious ... based on your schedule and amount of non critical databases, how many non critical ones you need to restore weekly (or daily) so you can cover all of them in a six month period?