ReportServerTempDB corruption in the log

  • dxu

    Old Hand

    Points: 329

    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

    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/

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

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