ChunkData table issue

  • dxu

    Old Hand

    Points: 329

    Hi ALL,

    When I backup the ReportServerTempDB and it was failed. Then I did a dbcc checkdb and got the error below.

    DBCC CHECKDB(ReportServerTempDB) WITH ALL_ERRORMSGS, NO_INFOMSGS

    Msg 8964, Level 16, State 1, Line 1

    Table error: Object ID 37575172, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594044416000 (type LOB data). The off-row data node at page (1:1167), slot 0, text ID 41234137088 is not referenced.

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

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

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

    However, when I do select * from ChunkData and it return nothing. I know the table is just storing some temporary data and not so important but I still want to get it fixed. I do not want to get anything wrong as I cannot backup this database now.

    Does anyone have had the same issue before? Do I need to do anything before I run the repair_allow_data_loss?

    Thanks heaps

    Daniel

  • dxu

    Old Hand

    Points: 329

    Anyone has got any idea?

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

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