ReportServerTempDB corruption in the log

• dxu

  Old Hand

  Points: 329

  July 20, 2016 at 5:49 pm

  #328024

  Hi,

  I have got error said Backup detected corruption in the database log when I backup the ReportServerTempDB in SQL server 2008.

  The database is in simple recovery mode.

  When I do dbcc checkdb, I have got this error:

  DBCC results for 'ChunkData'.

  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.

  There are 0 rows in 1 pages for object "ChunkData".

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

  Could someone please tell me what is ChunkData table? What could happen if I do repair_allow_data_loss?

  Thanks

  Daniel

• Jo Pattyn

  SSC-Dedicated

  Points: 31255

  July 18, 2017 at 8:47 am

  #1951428

  Chunkdata=temporary data fetched for report like for showing page Y of Z. If you can'r restore ,  repair_allow_data_loss will probably clean out (some of) the Chunkdata table as the clustered index is affected
  Read backup/restore techniques for RSTempDB: https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/backup-and-restore-operations-for-reporting-services
  About chunkdatatable: https://blogs.msdn.microsoft.com/sqlcat/2013/09/20/report-server-catalog-best-practices/