Home Forums SQL Server 7,2000 Data Corruption REPAIR_ALLOW_DATA_LOSS not resolving the allocation error RE: REPAIR_ALLOW_DATA_LOSS not resolving the allocation error

  • gail,

    the complete output for

    DBCC CHECKDB (ExampleProd3x) WITH NO_INFOMSGS, ALL_ERRORMSGS

    is

    Msg 2576, Level 16, State 1, Line 1

    The Index Allocation Map (IAM) page (0:0) is pointed to by the previous pointer of IAM page (1:3878384) in object ID 1591012749, index ID 22, partition ID 72057594103005184, alloc unit ID 72057594108379136 (type In-row data), but it was not detected in the scan.

    CHECKDB found 1 allocation errors and 0 consistency errors in table 'EXAMPLEUsers' (object ID 1591012749).

    CHECKDB found 1 allocation errors and 0 consistency errors in database 'ExampleProd3x'.

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (ExampleProd3x).

    thanks