Post reply

I don't want to use REPAIR_ALLOW_DATA_LOSS :(

  • June 7, 2010 at 2:50 am

    #223555

    DBCC CHECKDB 'DBNAME' WITH DATA_PURITY gives me following error.

    Msg 8909, Level 16, State 1, Line 1

    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:951) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).

    CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.

    Msg 8928, Level 16, State 1, Line 1

    Object ID 3033058998, index ID 1, partition ID 88757591278386009, alloc unit ID 72057594042384384 (type In-row data): Page (1:951) could not be processed. See other errors for details.

    I am getting error as attached to this post when I use REPAIR_FAST.

    I am left with only one option REPAIR_ALLOW_DATA_LOSS.

    Regards,

    Lucky

  • June 7, 2010 at 5:24 am

    #1177018

    The error says that the minimum level to repair is repair_allow_data_loss, so why are you wasting your time trying other options? (btw, repair_fast does nothing at all in SQL 2005+)

    Considering that this is one of Paul Randal's sample corruption databases (provided to let you play around with corruption), go ahead and repair it. One page of data from the 'sales' table will be lost.

    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

  • June 7, 2010 at 8:40 am

    #1177104

    Interesting - as those aren't the errors in the DemoRestoreOrRepair database I provide.

    Anyway, I don't understand the point of your post. CHECKDB is clearly telling you that you need to use REPAIR_ALLOW_DATA_LOSS. Unless you have a backup to restore from, you'll need to use that option - that's why I coded CHECKDB so it tells you what you need to do...

    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 3 posts - 1 through 2 (of 2 total)

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