ChunkData table issue

• dxu

  SSC-Addicted

  Points: 483

  More actions

  June 26, 2016 at 6:25 pm

  #327664

  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

  SSC-Addicted

  Points: 483

  More actions

  July 6, 2016 at 9:37 pm

  #1888838

  Anyone has got any idea?