Results 1 to 3 of 3

Thread: Dbcc Checkdb

  1. #1
    Join Date
    Aug 2006
    Posts
    27

    Red face Dbcc Checkdb

    hi guys

    I ran checkdb and found 4 error message on the db.. it seen like same object.. can anyone tell me what it is.. and how can i fix it? thanks !!!!

    1.
    Server: Msg 8976, Level 16, State 1, Line 35
    Table error: Object ID 2094630505, index ID 1. Page (1:809859) was not seen in the scan although its parent (1:77885) and previous (1:809767) refer to it. Check any previous errors.
    2.
    Server: Msg 8978, Level 16, State 1, Line 35
    Table error: Object ID 2094630505, index ID 1. Page (1:809860) is missing a reference from previous page (1:809859). Possible chain linkage problem.
    3.
    Server: Msg 8976, Level 16, State 1, Line 35
    Table error: Object ID 2094630505, index ID 1. Page (1:1453795) was not seen in the scan although its parent (1:1453347) and previous (1:1453796) refer to it. Check any previous errors.
    4.
    Server: Msg 8978, Level 16, State 1, Line 35
    Table error: Object ID 2094630505, index ID 1. Page (1:1453801) is missing a reference from previous page (1:1453795). Possible chain linkage problem.
    Last edited by a5718800; 10-25-2006 at 01:21 PM.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Seems index issue, try rebuild indexes on that table.

  3. #3
    Join Date
    Aug 2006
    Posts
    27
    guess what.. the index got same object id like the table..
    i removed the index.. and it goes with other table and same object id...
    how can this possible... i still look into it now... weird stuff...

Posting Permissions

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