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 Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 283
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
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11398 Visits: 1253
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
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18520 Visits: 10384
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