When I backup the ReportServerTempDB and it was failed. Then I did a dbcc checkdb and got the error below.
DBCC CHECKDB(ReportServerTempDB) WITH ALL_ERRORMSGS, NO_INFOMSGS
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.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'ChunkData' (object ID 37575172).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'ReportServerTempDB'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (ReportServerTempDB).
However, when I do select * from ChunkData and it return nothing. I know the table is just storing some temporary data and not so important but I still want to get it fixed. I do not want to get anything wrong as I cannot backup this database now.
Does anyone have had the same issue before? Do I need to do anything before I run the repair_allow_data_loss?