• bob199214 (9/15/2014)


    For the error message like this "Table error: Object ID 2121058592, index ID 1, partition ID 72057594038648832, alloc unit ID 72057594043629568 (type LOB data). The off-row data node at page (1:4911282), slot 0, text ID 35438133248 is referenced by page (1:4911275), slot 0, but was not seen in the scan.", which actually means a page (1:4911275) is referencing a slot in page (1:4911282), but the slot does not exist. Both page ID looks normal, so it is possible that one of the page is corrupt or both are corrupt.

    It means that one of the pages that was zeroed out contained text data, and since the page has been zeroed out, the scan couldn't find the off row data entry when it looked for it.

    In short, 24 pages or more of the data file has been overwritten with zeroes and multiple errors are being raised for each page damaged in that way. There's also some incorrect page IDs as well.

    The link you posted however is useless, it doesn't have any information at all about these specific errors.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass