• One thing I never encountered is corruption of a db. It makes me nervous for some reason just thinking about.

    Currently I backup and restore a few main production dbs to my DEv server and perform CHECKDB on a daily basis. The prod server is checked once a week. However I was under the impression that the DEV server would only check for logical errors or am I incorrect in that assumption.

    Thinking about it the physical corruption would be present in the backup file would it not. If it wasn't we could just restore the corrupted db from any backup after the corruption occured.

    Instead of going to a backup file before the corruption occured.