Data Corruption on a Database

  • Guys

    How can I fix this:

    Table error: Page (1:55957) allocated to object ID 546100986, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.

    And

    Table error: Object ID 546100986, index ID 1. B-tree chain linkage mismatch. (1:68327)->next = (1:156), but (1:156)->Prev = (1:152).

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

    Table error: Object ID 546100986, index ID 1. Page (1:1371) is missing references from parent (unknown) and previous (page (1:53603)) nodes. Possible bad root entry in sysindexes.

  • Are these the only errors in the output from CHECKDB? If not, please post the entire output.

    Thanks!

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

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

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