I had some errors in my dbcc checkdb output. Can I safely run this again with the repair_allow_data_loss option? What does this do?
asked Nov 10 '09 at 11:18 AM in Default
Steve Jones - Editor ♦♦
stolen from SQLTeam.com but;
1) I strongly advise not running repair if at all possible. The REPAIR_ALLOW_DATA_LOSS option is deliberately named that because it usually requires deleting data to obtain structural consistency of the database. Its far better to try to understand what the errors mean and the consequences of running repair are. The latest BOL update has full information for all errors that CHECKDB returns, including what repair will do. You should also strive to work out why these errors occured.
2) Running repair should be the last thing tried to recover from errors. Its always better to recover using up-to-date backups and/or extracting as much data as possible before running repair/restoring.
answered Nov 10 '09 at 11:44 AM