• You can't know what amount of data will be lost after running DBCC CHECKDB with repair_allow_data_loss.

    That's why it is the very, very last resort to try.

    See how emergency mode repair works at:

    http://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-emergency-mode-repair-the-very-very-last-resort/

    SQL Database Recovery Expert 🙂