Post reply

Error - Attempt to fetch logical page

  • August 13, 2003 at 4:25 pm

    #59090

    I have table with a Clustered Index on it.

    Whe I try dropping the index ig gives me the error as follows:

    Server: Msg 5180, Level 22, State 1, Line 1

    Could not open FCB for invalid file ID 28005 in database 'peter_oeminet'.

    Connection Broken

    Any idea what is this & how to fix it.

    I tried DBCC checktable & that gave me this error

    Server: Msg 8909, Level 16, State 1, Line 1

    Table error: Object ID -1836973831, index ID 28005, page ID (1:226920). The PageId in the page header = (11264:587203088).

    I tried DBCC DBREINDEX & that gave me

    Server: Msg 605, Level 12, State 1, Line 1

    Attempt to fetch logical page (1:226908) in database 'peter_oeminet' belongs to object '1764584805', not to object 'inetuser'.

    Any help?

    paul


    paul

  • August 14, 2003 at 4:05 pm

    #470029

    I'd run a full DBCC CHECKDB to determine the extent of the corruption, but I think it sounds like some sort of hardware error. Also if you are running version 7.0, there are some know issues that may cause this error (5180).

    The 605 error indicates cross-linkage in a table, in other words, a data/index page for one object points to a page that belongs to another object.

    -Dan


    -Dan

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply