Detailed Information about Data Loss When Repairing With CHECKDB

Symptom:

When using DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS parameter to repair a corrupt .MDF database, like this:

DBCC CHECKDB(xxxx, ‘REPAIR_ALLOW_DATA_LOSS’)

you see the following error message:

DBCC results for ‘Error1’.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
DBCC results for ‘sys.sysrscols’.
There are 1092 rows in 14 pages for object “sys.sysrscols”.
DBCC results for ‘sys.sysrowsets’.
There are 148 rows in 3 pages for object “sys.sysrowsets”.
DBCC results for ‘sys.sysclones’.
There are 0 rows in 0 pages for object “sys.sysclones”.
DBCC results for ‘sys.sysallocunits’.
There are 172 rows in 2 pages for object “sys.sysallocunits”.
DBCC results for ‘sys.sysfiles1’.
There are 2 rows in 1 pages for object “sys.sysfiles1”.
DBCC results for ‘sys.sysseobjvalues’.
There are 0 rows in 0 pages for object “sys.sysseobjvalues”.
DBCC results for ‘sys.syspriorities’.
There are 0 rows in 0 pages for object “sys.syspriorities”.
DBCC results for ‘sys.sysdbfrag’.
There are 0 rows in 0 pages for object “sys.sysdbfrag”.
DBCC results for ‘sys.sysfgfrag’.
There are 0 rows in 0 pages for object “sys.sysfgfrag”.
DBCC results for ‘sys.sysdbfiles’.
There are 2 rows in 1 pages for object “sys.sysdbfiles”.
DBCC results for ‘sys.syspru’.
There are 0 rows in 0 pages for object “sys.syspru”.
DBCC results for ‘sys.sysbrickfiles’.
There are 0 rows in 0 pages for object “sys.sysbrickfiles”.
DBCC results for ‘sys.sysphfg’.
There are 1 rows in 1 pages for object “sys.sysphfg”.
DBCC results for ‘sys.sysprufiles’.
There are 2 rows in 1 pages for object “sys.sysprufiles”.
DBCC results for ‘sys.sysftinds’.
There are 0 rows in 0 pages for object “sys.sysftinds”.
DBCC results for ‘sys.sysowners’.
There are 14 rows in 1 pages for object “sys.sysowners”.
DBCC results for ‘sys.sysdbreg’.
There are 0 rows in 0 pages for object “sys.sysdbreg”.
DBCC results for ‘sys.sysprivs’.
There are 140 rows in 1 pages for object “sys.sysprivs”.
DBCC results for ‘sys.sysschobjs’.
There are 2262 rows in 29 pages for object “sys.sysschobjs”.
DBCC results for ‘sys.syscsrowgroups’.
There are 0 rows in 0 pages for object “sys.syscsrowgroups”.
DBCC results for ‘sys.sysexttables’.
There are 0 rows in 0 pages for object “sys.sysexttables”.
DBCC results for ‘sys.syscolpars’.
There are 888 rows in 16 pages for object “sys.syscolpars”.
DBCC results for ‘sys.sysxlgns’.
There are 0 rows in 0 pages for object “sys.sysxlgns”.
DBCC results for ‘sys.sysxsrvs’.
There are 0 rows in 0 pages for object “sys.sysxsrvs”.
DBCC results for ‘sys.sysnsobjs’.
There are 1 rows in 1 pages for object “sys.sysnsobjs”.
DBCC results for ‘sys.sysusermsgs’.
There are 0 rows in 0 pages for object “sys.sysusermsgs”.
DBCC results for ‘sys.syscerts’.
There are 0 rows in 0 pages for object “sys.syscerts”.
DBCC results for ‘sys.sysrmtlgns’.
There are 0 rows in 0 pages for object “sys.sysrmtlgns”.
DBCC results for ‘sys.syslnklgns’.
There are 0 rows in 0 pages for object “sys.syslnklgns”.
DBCC results for ‘sys.sysxprops’.
There are 0 rows in 0 pages for object “sys.sysxprops”.
DBCC results for ‘sys.sysscalartypes’.
There are 34 rows in 1 pages for object “sys.sysscalartypes”.
DBCC results for ‘sys.systypedsubobjs’.
There are 0 rows in 0 pages for object “sys.systypedsubobjs”.
DBCC results for ‘sys.sysidxstats’.
There are 207 rows in 5 pages for object “sys.sysidxstats”.
DBCC results for ‘sys.sysiscols’.
There are 399 rows in 2 pages for object “sys.sysiscols”.
DBCC results for ‘sys.sysendpts’.
There are 0 rows in 0 pages for object “sys.sysendpts”.
DBCC results for ‘sys.syswebmethods’.
There are 0 rows in 0 pages for object “sys.syswebmethods”.
DBCC results for ‘sys.sysbinobjs’.
There are 23 rows in 1 pages for object “sys.sysbinobjs”.
DBCC results for ‘sys.sysaudacts’.
There are 0 rows in 0 pages for object “sys.sysaudacts”.
DBCC results for ‘sys.sysobjvalues’.
There are 213 rows in 21 pages for object “sys.sysobjvalues”.
DBCC results for ‘sys.syscscolsegments’.
There are 0 rows in 0 pages for object “sys.syscscolsegments”.
DBCC results for ‘sys.syscsdictionaries’.
There are 0 rows in 0 pages for object “sys.syscsdictionaries”.
DBCC results for ‘sys.sysclsobjs’.
There are 16 rows in 1 pages for object “sys.sysclsobjs”.
DBCC results for ‘sys.sysrowsetrefs’.
There are 0 rows in 0 pages for object “sys.sysrowsetrefs”.
DBCC results for ‘sys.sysremsvcbinds’.
There are 0 rows in 0 pages for object “sys.sysremsvcbinds”.
DBCC results for ‘sys.sysxmitqueue’.
There are 0 rows in 0 pages for object “sys.sysxmitqueue”.
DBCC results for ‘sys.sysrts’.
There are 1 rows in 1 pages for object “sys.sysrts”.
DBCC results for ‘sys.sysconvgroup’.
There are 0 rows in 0 pages for object “sys.sysconvgroup”.
DBCC results for ‘sys.sysdesend’.
There are 0 rows in 0 pages for object “sys.sysdesend”.
DBCC results for ‘sys.sysdercv’.
There are 0 rows in 0 pages for object “sys.sysdercv”.
DBCC results for ‘sys.syssingleobjrefs’.
There are 171 rows in 1 pages for object “sys.syssingleobjrefs”.
DBCC results for ‘sys.sysmultiobjrefs’.
There are 107 rows in 1 pages for object “sys.sysmultiobjrefs”.
DBCC results for ‘sys.sysguidrefs’.
There are 0 rows in 0 pages for object “sys.sysguidrefs”.
DBCC results for ‘sys.sysfoqueues’.
There are 0 rows in 0 pages for object “sys.sysfoqueues”.
DBCC results for ‘sys.syschildinsts’.
There are 0 rows in 0 pages for object “sys.syschildinsts”.
DBCC results for ‘sys.syscompfragments’.
There are 0 rows in 0 pages for object “sys.syscompfragments”.
DBCC results for ‘sys.sysftsemanticsdb’.
There are 0 rows in 0 pages for object “sys.sysftsemanticsdb”.
DBCC results for ‘sys.sysftstops’.
There are 0 rows in 0 pages for object “sys.sysftstops”.
DBCC results for ‘sys.sysftproperties’.
There are 0 rows in 0 pages for object “sys.sysftproperties”.
DBCC results for ‘sys.sysxmitbody’.
There are 0 rows in 0 pages for object “sys.sysxmitbody”.
DBCC results for ‘sys.sysfos’.
There are 0 rows in 0 pages for object “sys.sysfos”.
DBCC results for ‘sys.sysqnames’.
There are 98 rows in 1 pages for object “sys.sysqnames”.
DBCC results for ‘sys.sysxmlcomponent’.
There are 100 rows in 1 pages for object “sys.sysxmlcomponent”.
DBCC results for ‘sys.sysxmlfacet’.
There are 112 rows in 1 pages for object “sys.sysxmlfacet”.
DBCC results for ‘sys.sysxmlplacement’.
There are 19 rows in 1 pages for object “sys.sysxmlplacement”.
DBCC results for ‘sys.sysobjkeycrypts’.
There are 0 rows in 0 pages for object “sys.sysobjkeycrypts”.
DBCC results for ‘sys.sysasymkeys’.
There are 0 rows in 0 pages for object “sys.sysasymkeys”.
DBCC results for ‘sys.syssqlguides’.
There are 0 rows in 0 pages for object “sys.syssqlguides”.
DBCC results for ‘sys.sysbinsubobjs’.
There are 3 rows in 1 pages for object “sys.sysbinsubobjs”.
DBCC results for ‘sys.syssoftobjrefs’.
There are 0 rows in 0 pages for object “sys.syssoftobjrefs”.
DBCC results for ‘sys.plan_persist_plan’.
There are 0 rows in 0 pages for object “sys.plan_persist_plan”.
DBCC results for ‘sys.plan_persist_runtime_stats’.
There are 0 rows in 0 pages for object “sys.plan_persist_runtime_stats”.
DBCC results for ‘sys.plan_persist_runtime_stats_interval’.
There are 0 rows in 0 pages for object “sys.plan_persist_runtime_stats_interval”.
DBCC results for ‘sys.plan_persist_context_settings’.
There are 0 rows in 0 pages for object “sys.plan_persist_context_settings”.
DBCC results for ‘sys.sqlagent_jobs’.
There are 0 rows in 0 pages for object “sys.sqlagent_jobs”.
DBCC results for ‘sys.sqlagent_jobsteps’.
There are 0 rows in 0 pages for object “sys.sqlagent_jobsteps”.
DBCC results for ‘sys.sqlagent_job_history’.
There are 0 rows in 0 pages for object “sys.sqlagent_job_history”.
DBCC results for ‘sys.sqlagent_jobsteps_logs’.
There are 0 rows in 0 pages for object “sys.sqlagent_jobsteps_logs”.
DBCC results for ‘TestTable’.
Repair: The page (1:183) has been deallocated from object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045792256 (type In-row data).
Repair: Deleted off-row data column with ID 177012736, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 70.
Repair: Deleted off-row data column with ID 177078272, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 71.
Repair: Deleted off-row data column with ID 177143808, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 72.
Repair: Deleted off-row data column with ID 177209344, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 73.
Repair: Deleted off-row data column with ID 177274880, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 74.
Repair: Deleted off-row data column with ID 177340416, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 75.
Repair: Deleted off-row data column with ID 177405952, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 76.
Repair: Deleted off-row data column with ID 177471488, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 77.
Repair: Deleted off-row data column with ID 177537024, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 78.
Repair: Deleted off-row data column with ID 177602560, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 79.
Repair: Deleted off-row data column with ID 177668096, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 80.
Repair: Deleted off-row data column with ID 177733632, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 81.
Repair: Deleted off-row data column with ID 177799168, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 82.
Repair: Deleted off-row data column with ID 177864704, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 83.
Repair: Deleted off-row data column with ID 177930240, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 84.
Repair: Deleted off-row data column with ID 177995776, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 85.
Repair: Deleted off-row data column with ID 178061312, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 86.
Repair: Deleted off-row data column with ID 178126848, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 87.
Repair: Deleted off-row data column with ID 178192384, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 88.
Repair: Deleted off-row data column with ID 178257920, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:182), slot 89.
Repair: Deleted off-row data column with ID 178323456, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 0.
Repair: Deleted off-row data column with ID 178388992, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 1.
Repair: Deleted off-row data column with ID 178454528, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 2.
Repair: Deleted off-row data column with ID 178520064, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 3.
Repair: Deleted off-row data column with ID 178585600, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 4.
Repair: Deleted off-row data column with ID 178651136, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 5.
Repair: Deleted off-row data column with ID 178716672, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 6.
Repair: Deleted off-row data column with ID 178782208, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 7.
Repair: Deleted off-row data column with ID 178847744, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 8.
Repair: Deleted off-row data column with ID 178913280, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 9.
Repair: Deleted off-row data column with ID 178978816, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 10.
Repair: Deleted off-row data column with ID 179044352, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 11.
Repair: Deleted off-row data column with ID 179109888, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 12.
Repair: Deleted off-row data column with ID 179175424, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 13.
Repair: Deleted off-row data column with ID 179240960, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 14.
Repair: Deleted off-row data column with ID 179306496, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 15.
Repair: Deleted off-row data column with ID 179372032, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 16.
Repair: Deleted off-row data column with ID 179437568, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 17.
Repair: Deleted off-row data column with ID 179503104, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 18.
Repair: Deleted off-row data column with ID 179568640, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 19.
Repair: Deleted off-row data column with ID 179634176, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 20.
Repair: Deleted off-row data column with ID 179699712, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 21.
Repair: Deleted off-row data column with ID 179765248, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 22.
Repair: Deleted off-row data column with ID 179830784, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 23.
Repair: Deleted off-row data column with ID 179896320, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 24.
Repair: Deleted off-row data column with ID 179961856, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 25.
Repair: Deleted off-row data column with ID 180027392, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 26.
Repair: Deleted off-row data column with ID 180092928, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 27.
Repair: Deleted off-row data column with ID 180158464, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 28.
Repair: Deleted off-row data column with ID 180224000, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 29.
Repair: Deleted off-row data column with ID 180289536, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 30.
Repair: Deleted off-row data column with ID 180355072, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 31.
Repair: Deleted off-row data column with ID 180420608, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 32.
Repair: Deleted off-row data column with ID 180486144, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 33.
Repair: Deleted off-row data column with ID 180551680, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 34.
Repair: Deleted off-row data column with ID 180617216, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 35.
Repair: Deleted off-row data column with ID 180682752, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 36.
Repair: Deleted off-row data column with ID 180748288, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 37.
Repair: Deleted off-row data column with ID 180813824, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 38.
Repair: Deleted off-row data column with ID 180879360, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 39.
Repair: Deleted off-row data column with ID 180944896, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 40.
Repair: Deleted off-row data column with ID 181010432, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 41.
Repair: Deleted off-row data column with ID 181075968, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 42.
Repair: Deleted off-row data column with ID 181141504, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 43.
Repair: Deleted off-row data column with ID 181207040, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 44.
Repair: Deleted off-row data column with ID 181272576, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 45.
Repair: Deleted off-row data column with ID 181338112, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 46.
Repair: Deleted off-row data column with ID 181403648, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 47.
Repair: Deleted off-row data column with ID 181469184, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 48.
Repair: Deleted off-row data column with ID 181534720, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 49.
Repair: Deleted off-row data column with ID 181600256, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 50.
Repair: Deleted off-row data column with ID 181665792, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 51.
Repair: Deleted off-row data column with ID 181731328, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 52.
Repair: Deleted off-row data column with ID 181796864, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 53.
Repair: Deleted off-row data column with ID 181862400, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 54.
Repair: Deleted off-row data column with ID 181927936, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 55.
Repair: Deleted off-row data column with ID 181993472, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 56.
Repair: Deleted off-row data column with ID 182059008, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 57.
Repair: Deleted off-row data column with ID 182124544, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 58.
Repair: Deleted off-row data column with ID 182190080, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 59.
Repair: Deleted off-row data column with ID 182255616, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 60.
Repair: Deleted off-row data column with ID 182321152, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 61.
Repair: Deleted off-row data column with ID 182386688, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 62.
Repair: Deleted off-row data column with ID 182452224, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 63.
Repair: Deleted off-row data column with ID 182517760, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 64.
Repair: Deleted off-row data column with ID 182583296, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 65.
Repair: Deleted off-row data column with ID 182648832, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 66.
Repair: Deleted off-row data column with ID 182714368, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 67.
Repair: Deleted off-row data column with ID 182779904, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 68.
Repair: Deleted off-row data column with ID 182845440, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 69.
Repair: Deleted off-row data column with ID 182910976, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 70.
Repair: Deleted off-row data column with ID 182976512, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 71.
Repair: Deleted off-row data column with ID 183042048, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 72.
Repair: Deleted off-row data column with ID 183107584, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 73.
Repair: Deleted off-row data column with ID 183173120, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 74.
Repair: Deleted off-row data column with ID 183238656, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 75.
Repair: Deleted off-row data column with ID 183304192, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 76.
Repair: Deleted off-row data column with ID 183369728, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 77.
Repair: Deleted off-row data column with ID 183435264, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 78.
Repair: Deleted off-row data column with ID 183500800, for object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) on page (1:216), slot 79.
Repair: The Nonclustered index successfully rebuilt for the object “dbo.TestTable, IX_TestTable” in database “Error1”.
Msg 8928, Level 16, State 1, Line 8
Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045792256 (type In-row data): Page (1:183) could not be processed. See other errors for details.
The error has been repaired.
Msg 8939, Level 16, State 98, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045792256 (type In-row data), page (1:183). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.
The error has been repaired.
Msg 8939, Level 16, State 98, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045792256 (type In-row data), page (1:183). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 70, text ID 177012736 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 71, text ID 177078272 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 72, text ID 177143808 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 73, text ID 177209344 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 74, text ID 177274880 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 75, text ID 177340416 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 76, text ID 177405952 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 77, text ID 177471488 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 78, text ID 177537024 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 79, text ID 177602560 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 80, text ID 177668096 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 81, text ID 177733632 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 82, text ID 177799168 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 83, text ID 177864704 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 84, text ID 177930240 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 85, text ID 177995776 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 86, text ID 178061312 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 87, text ID 178126848 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 88, text ID 178192384 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:182), slot 89, text ID 178257920 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 0, text ID 178323456 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 1, text ID 178388992 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 2, text ID 178454528 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 3, text ID 178520064 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 4, text ID 178585600 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 5, text ID 178651136 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 6, text ID 178716672 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 7, text ID 178782208 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 8, text ID 178847744 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 9, text ID 178913280 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 10, text ID 178978816 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 11, text ID 179044352 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 12, text ID 179109888 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 13, text ID 179175424 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 14, text ID 179240960 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 15, text ID 179306496 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 16, text ID 179372032 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 17, text ID 179437568 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 18, text ID 179503104 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 19, text ID 179568640 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 20, text ID 179634176 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 21, text ID 179699712 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 22, text ID 179765248 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 23, text ID 179830784 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 24, text ID 179896320 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 25, text ID 179961856 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 26, text ID 180027392 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 27, text ID 180092928 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 28, text ID 180158464 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 29, text ID 180224000 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 30, text ID 180289536 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 31, text ID 180355072 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 32, text ID 180420608 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 33, text ID 180486144 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 34, text ID 180551680 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 35, text ID 180617216 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 36, text ID 180682752 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 37, text ID 180748288 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 38, text ID 180813824 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 39, text ID 180879360 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 40, text ID 180944896 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 41, text ID 181010432 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 42, text ID 181075968 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 43, text ID 181141504 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 44, text ID 181207040 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 45, text ID 181272576 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 46, text ID 181338112 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 47, text ID 181403648 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 48, text ID 181469184 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 49, text ID 181534720 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 50, text ID 181600256 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 51, text ID 181665792 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 52, text ID 181731328 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 53, text ID 181796864 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 54, text ID 181862400 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 55, text ID 181927936 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 56, text ID 181993472 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 57, text ID 182059008 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 58, text ID 182124544 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 59, text ID 182190080 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 60, text ID 182255616 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 61, text ID 182321152 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 62, text ID 182386688 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 63, text ID 182452224 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 64, text ID 182517760 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 65, text ID 182583296 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 66, text ID 182648832 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 67, text ID 182714368 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 68, text ID 182779904 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 69, text ID 182845440 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 70, text ID 182910976 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 71, text ID 182976512 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 72, text ID 183042048 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 73, text ID 183107584 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 74, text ID 183173120 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 75, text ID 183238656 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 76, text ID 183304192 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 77, text ID 183369728 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 78, text ID 183435264 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data). The off-row data node at page (1:216), slot 79, text ID 183500800 is not referenced.
The error has been repaired.
Msg 8945, Level 16, State 1, Line 8
Table error: Object ID 245575913, index ID 2 will be rebuilt.
The error has been repaired.
There are 10900 rows in 109 pages for object “TestTable”.
CHECKDB found 0 allocation errors and 103 consistency errors in table ‘TestTable’ (object ID 245575913).
CHECKDB fixed 0 allocation errors and 103 consistency errors in table ‘TestTable’ (object ID 245575913).
DBCC results for ‘sys.queue_messages_1977058079’.
There are 0 rows in 0 pages for object “sys.queue_messages_1977058079”.
DBCC results for ‘sys.queue_messages_2009058193’.
There are 0 rows in 0 pages for object “sys.queue_messages_2009058193”.
DBCC results for ‘sys.queue_messages_2041058307’.
There are 0 rows in 0 pages for object “sys.queue_messages_2041058307”.
DBCC results for ‘sys.filestream_tombstone_2073058421’.
There are 0 rows in 0 pages for object “sys.filestream_tombstone_2073058421”.
DBCC results for ‘sys.syscommittab’.
There are 0 rows in 0 pages for object “sys.syscommittab”.
DBCC results for ‘sys.filetable_updates_2105058535’.
There are 0 rows in 0 pages for object “sys.filetable_updates_2105058535”.
DBCC results for ‘sys.plan_persist_query_text’.
There are 0 rows in 0 pages for object “sys.plan_persist_query_text”.
DBCC results for ‘sys.plan_persist_query’.
There are 0 rows in 0 pages for object “sys.plan_persist_query”.
CHECKDB found 0 allocation errors and 103 consistency errors in database ‘Error1’.
CHECKDB fixed 0 allocation errors and 103 consistency errors in database ‘Error1’.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

where ‘Error1’ is name of the corrupt MDF database being repaired.

CHECKDB is able to find and repair the errors. However, in the fixed database, 100 records are lost.

Screenshot of error message:

Precise Explanation:

When CHECKDB finds any errors in the corrupt database, and you specify REPAIR_ALLOW_DATA_LOSS parameter, then it will try to repair the database and some of the damaged records may be abandoned during the repair process.

Actually these abandoned records can also be recovered, if using our product DataNumen SQL Recovery to do the task.

In the following sample corrupt MDF file, if using CHECKDB with REPAIR_ALLOW_DATA_LOSS parameter, then 100 records will be lost. But with DataNumen SQL Recovery, only one record will be lost, the remaining 99 records can still be recovered.

Sample Files:

Sample corrupt MDF files on which CHECKDB REPAIR_ALLOW_DATA_LOSS will lose 100 records, but DataNumen SQL Recovery will only lose one.

SQL Server version	Corrupt MDF file	MDF file fixed by DataNumen SQL Recovery
SQL Server 2014	Error7.mdf	Error7_fixed.mdf