July 20, 2016 at 5:49 pm
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
July 18, 2017 at 8:47 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy