Home Forums SQL Server 2014 Administration - SQL Server 2014 data loss RE: data loss
prettsons
SSCertifiable
Points: 7453
More actions
January 18, 2015 at 10:45 pm
#1771029
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 🙂