DBCC reported consistency errors on one of the tables in our data warehouse database. The problem was corrected and the data restored, but I would like to prevent these type of errors. Other than a failure of a disk drive or controller, what can cause the types of errors that DBCC reports? What steps can I take to minimize these problems? We are already using RAID 10 for Our data warehouse data files. I thought this would protect us from consistency errors.
Edited by - dcurtis on 04/04/2003 2:47:04 PM