DBCC checkdb report error : marked allocated in the GAM, but no SGAM or IAM has allocated it.

Question

hi folks:
DBCC check reported error: marked allocated in the GAM, but no SGAM or IAM has allocated it.
and I've used dbcc check with repair_allow_data_loss . It did fix all allocation errors.

Question: Did I still lose any data ?

Thanks

Hui

Answer 1

No object in the database has assigned that extent (1 allocation error … not associated with any single object).

Answer 2

As you know Repair allow data loss explicitly indicates that SQL Server can try to recover with a data loss as well. So, the best way to know whether we have any data loss or not is by comparing or verifying the last known data with repaired database