• It is worth mentioning that after a repair with data loss, not only is the corrupted record lost, but the whole data page. The good news is that with a good backup strategy, the lost page can be restored from backups.

    Considering that the transaction is written to the transaction logs before committed to the database, you may get lucky and have no data loss after restoring the page.