Talib123 (9/12/2013)
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.
Yes physical corruption will be present in the backup which is why restoring a backup and doing CHECKDB against it is an acceptable practice.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question