dbcc checkdb fails (file stream)
I have a database that contains a file stram. This database fails when I run dbcc checkdb againest it, below is the error message:
Msg 2576, Level 16, State 1, Line 1
The Index Allocation Map (IAM) page (0:0) is pointed to by the previous pointer of IAM page (1:204) in object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594054901760 (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.
I made a backup of the existing DB, created a new DB, and restored the existing DB to the new one but I still got the error. I then did treid rebuild with and without data loss, but none seeemed to fixed the issue. What is your recommendation?
