Results 1 to 3 of 3

Thread: dbcc checkdb fails (file stream)

  1. #1
    Join Date
    Dec 2002
    Posts
    50

    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?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Rebuild all indices then try again.

  3. #3
    Join Date
    Dec 2002
    Posts
    50
    Quote Originally Posted by rmiao View Post
    Rebuild all indices then try again.
    I already rebuild all indexes, still getting the error!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •