Post reply

DB corruption error 8905, fixed using repair_allow_data_loss ,

  • January 15, 2021 at 4:30 pm

    #3833845

    hi all, I need some help here.

    Recently, I've found a db with error 8905... error suggested using repair_allow_data_loss . Since I have no clean backup because I inherited from someone else...

    Error  before fix:

    Msg 8905, Level 16, State 1, Line 5

    Extent (1:7546104) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    Msg 8905, Level 16, State 1, Line 5

    Extent (1:7554192) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    Msg 8905, Level 16, State 1, Line 5

    Extent (1:7562280) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    Msg 8905, Level 16, State 1, Line 5

    Extent (1:7570368) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    CHECKDB found 127 allocation errors and 0 consistency errors in database 'DWH_LANDING'.

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DWH_LANDING, repair_rebuild).

    after fix:

    =========

    Extent (1:6656424) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    The error has been repaired.

    Msg 8905, Level 16, State 1, Line 5

    Extent (1:6664512) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    The error has been repaired.

    Msg 8905, Level 16, State 1, Line 5

    Extent (1:6672600) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    The error has been repaired.

    Msg 8905, Level 16, State 1, Line 5

    Extent (1:6680688) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    The error has been repaired.

    CHECKDB found 127 allocation errors and 0 consistency errors in database 'DWH_LANDING'.

    CHECKDB fixed 127 allocation errors and 0 consistency errors in database 'DWH_LANDING'.

     

    question:

    =============

    Is there any data loss during the process? this is the million dollar question!!

     

    Thanks a lot!

     

     

     

     

  • January 15, 2021 at 4:36 pm

    #3833856

    Is there anyway to know what resides in Extent 1 ? if it's not data pages?

     

    thanks

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

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