Paul Randal,

What would you suggest for those that cannot do the 'verify backup integrity' due to time constraits?

In my environment we have multiple production database clusters, each with multiple TB databases.

1) It doesn't seem feasible to use 'verify backup integrity' because of the extra time requirements.

2) Restoring all of the backups elsewhere does not seem viable just due to the number of backups that exist.

We are requested to refresh QA, Dev or Performance testing environments every few weeks. So we do take prod backups and restore them elsewhere. But there is not a fixed schedule for this.

So what would be suggested then? Thanks