SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


ReportServerTempDB corruption in the log


ReportServerTempDB corruption in the log

Author
Message
dxu
dxu
SSC Veteran
SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)

Group: General Forum Members
Points: 209 Visits: 301
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
Lincoln Burrows
Lincoln Burrows
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16923 Visits: 2181
It looks as though the DBCC CHECKDB has found a problem...

Although this may not be considered "serious", I would recommend dealing with it as a priority.

firstly, you should have a healthy valid backup.

Using Repair_Allow is restricted as this will delete some data.

You may use one of good SQL Log Analyzer to repair your database without any loss.
Jo Pattyn
Jo Pattyn
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28278 Visits: 10918
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/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search