i have a 1.6TB database which got corrupted due to some LUN issue. i fixed most of the corruption through DBCC (storage also checked out) but i still getting 1 allocation issue regardless how many times i run DBCC with allow data loss/repair/rebuild. DBCC reports that it fixed the allocation but if i run checkdb again it reports back 1 allocation error. at this point we do not have a 'clean' backup to restore from and i'm running out of ideas. any help is much appreciated. do i need reboot after each repair because the only thing i didnt do was reboot the machine since its production and i rebuilt indexes on each table that didnt help either
Msg 2575, Level 16, State 1, Line 1
The Index Allocation Map (IAM) page (13:1546477) is pointed to by the next pointer of IAM page (0:0) in object ID 0, index ID -1, partition ID 0, alloc unit ID 72057621802647552 (type Unknown), but it was not detected in the scan.
CHECKDB found 1 allocation errors and 0 consistency errors not associated with any single object.
CHECKDB found 1 allocation errors and 0 consistency errors in database 'mydb'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (mydb).