December 20, 2011 at 10:08 am
I'm embarrassed to have to ask this, but I'm a bit of a n00b. I know there are different approaches to resolving corruption based on whether the corruption is logical or physical. And I know what each means. What I don't know is how to interpret the results of CHECKDB as to which type of corruption it is. For example:
example #1:
DBCC results for 'JBM_TPSH'.
Msg 8928, Level 16, State 1, Line 1
Object ID 617769258, index ID 1, partition ID 72057594090815488, alloc unit ID 72057594101301248 (type In-row data): Page (1:43736) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 617769258, index ID 1, partition ID 72057594090815488, alloc unit ID 72057594101301248 (type In-row data), page (1:43736). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 617769258, index ID 1, partition ID 72057594090815488, alloc unit ID 72057594101301248 (type In-row data). Page (1:43736) was not seen in the scan although its parent (1:6735) and previous (1:42753) refer to it. Check any previous errors.
There are 2221 rows in 25 pages for object "JBM_TPSH".
CHECKDB found 0 allocation errors and 3 consistency errors in table 'JBM_TPSH' (object ID 617769258).
example #2:
DBCC results for 'JBM_BCMPColumns'.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1463676262, index ID 2, partition ID 72057594068598784, alloc unit ID 72057594076463104 (type In-row data). Page (1:43683) is missing a reference from previous page (1:43685). Possible chain linkage problem.
Msg 8928, Level 16, State 1, Line 1
Object ID 1463676262, index ID 2, partition ID 72057594068598784, alloc unit ID 72057594076463104 (type In-row data): Page (1:43685) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1463676262, index ID 2, partition ID 72057594068598784, alloc unit ID 72057594076463104 (type In-row data), page (1:43685). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1463676262, index ID 2, partition ID 72057594068598784, alloc unit ID 72057594076463104 (type In-row data). Page (1:43685) was not seen in the scan although its parent (1:44763) and previous (1:43686) refer to it. Check any previous errors.
There are 155062 rows in 1732 pages for object "JBM_BCMPColumns".
CHECKDB found 0 allocation errors and 4 consistency errors in table 'JBM_BCMPColumns' (object ID 1463676262).
All I know is that I'm looking at corruption, and if I knew how to interpret this, I think I could establish a game plan -- which I'm assuming is a restore of the last known good backup, but if I can save the last few hours' worth of work, I know a few people who would be very appreciative.
I suspect I'm looking at a hardware issue, as yesterday's check only showed the first instance of corruption. I told certain people to stop working, but they didn't, and today's check shows the second as well. So the problem seems to be progressing.
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 20, 2011 at 10:39 am
In both cases a page has been mangled (has incorrect values). The first one is in the clustered index, so the actual data, the second is in a nonclustered index, so a redundant copy of the data.
As for how to fix, you posted an incomplete checkDB output, there's at least one, hopefully two more lines to the output. Please post them.
Check your IO subsystem, corruption is usually IO subsystem problems
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2011 at 10:55 am
GilaMonster (12/20/2011)
As for how to fix, you posted an incomplete checkDB output, there's at least one, hopefully two more lines to the output. Please post them.
Sorry, I was hoping to spare anyone from having to look through all that text. See below.
Check your IO subsystem, corruption is usually IO subsystem problems
I suspect the same, though it's not always easy to convince an IT guy that it's on his end, y'know?
thanks
ron
=================
DBCC results for 'CE_DATA'.
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.
DBCC results for 'sys.sysrowsetcolumns'.
There are 6936 rows in 41 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 841 rows in 5 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 967 rows in 10 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 6936 rows in 49 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 841 rows in 5 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 967 rows in 5 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 14 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 120 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 4303 rows in 92 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 12930 rows in 233 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 542 rows in 17 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 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 1649 rows in 30 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 2297 rows in 14 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 4672 rows in 1325 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 14 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 1153 rows in 10 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 33177 rows in 218 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 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 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'FRM_Settings'.
There are 0 rows in 0 pages for object "FRM_Settings".
DBCC results for 'TRC_IssuesCO'.
There are 0 rows in 0 pages for object "TRC_IssuesCO".
DBCC results for 'BID_BCMPColumns'.
There are 20423 rows in 190 pages for object "BID_BCMPColumns".
DBCC results for 'IMP_BID_BondCalc'.
There are 0 rows in 1 pages for object "IMP_BID_BondCalc".
DBCC results for 'TRC_PODetailTasks'.
There are 0 rows in 0 pages for object "TRC_PODetailTasks".
DBCC results for 'JBM_CSTakeoffGroups_Rows'.
There are 0 rows in 0 pages for object "JBM_CSTakeoffGroups_Rows".
DBCC results for 'FRM_System_Categories'.
There are 6 rows in 2 pages for object "FRM_System_Categories".
DBCC results for 'NEC_Table_5_7_1B'.
There are 12 rows in 1 pages for object "NEC_Table_5_7_1B".
DBCC results for 'IMP_BID_LaborAdjustCalc'.
There are 0 rows in 1 pages for object "IMP_BID_LaborAdjustCalc".
DBCC results for 'FRM_System_Fixtures'.
There are 52 rows in 2 pages for object "FRM_System_Fixtures".
DBCC results for 'TRC_IssueSubContDelays'.
There are 0 rows in 0 pages for object "TRC_IssueSubContDelays".
DBCC results for 'JBM_BidQuoteAttributes'.
There are 0 rows in 0 pages for object "JBM_BidQuoteAttributes".
DBCC results for 'IMP_BID_OHCalc'.
There are 0 rows in 1 pages for object "IMP_BID_OHCalc".
DBCC results for 'GEN_AccessLevelDetails'.
There are 207 rows in 1 pages for object "GEN_AccessLevelDetails".
DBCC results for 'BID_BFCT'.
There are 2691 rows in 18 pages for object "BID_BFCT".
DBCC results for 'NEC_Table_5_7_2A'.
There are 7 rows in 1 pages for object "NEC_Table_5_7_2A".
DBCC results for 'JBM_TasksMaterial'.
There are 0 rows in 0 pages for object "JBM_TasksMaterial".
DBCC results for 'IMP_BID_ProfitCalc'.
There are 0 rows in 1 pages for object "IMP_BID_ProfitCalc".
DBCC results for 'JBM_CSTakeoffList'.
There are 0 rows in 0 pages for object "JBM_CSTakeoffList".
DBCC results for 'JBM_BIDS'.
There are 75 rows in 1 pages for object "JBM_BIDS".
DBCC results for 'ITM_Item_Field_Import'.
There are 0 rows in 0 pages for object "ITM_Item_Field_Import".
DBCC results for 'IMP_BID_SelectValueCalc'.
There are 0 rows in 0 pages for object "IMP_BID_SelectValueCalc".
DBCC results for 'TRC_POInventoryReq_Temp'.
There are 0 rows in 0 pages for object "TRC_POInventoryReq_Temp".
DBCC results for 'TRC_IssueToolsDelays'.
There are 0 rows in 0 pages for object "TRC_IssueToolsDelays".
DBCC results for 'NEC_Table_5_7_2B'.
There are 4 rows in 1 pages for object "NEC_Table_5_7_2B".
DBCC results for 'IMP_BID_STDCALC'.
There are 0 rows in 34 pages for object "IMP_BID_STDCALC".
DBCC results for 'JBM_PhaseDefaultJobSettings'.
There are 4 rows in 1 pages for object "JBM_PhaseDefaultJobSettings".
DBCC results for 'JBM_CSTakeoffList_Rows'.
There are 0 rows in 0 pages for object "JBM_CSTakeoffList_Rows".
DBCC results for 'IMP_BID_TPSH'.
There are 0 rows in 1 pages for object "IMP_BID_TPSH".
DBCC results for 'NEC_Table_5_7_4'.
There are 25 rows in 1 pages for object "NEC_Table_5_7_4".
DBCC results for 'IMP_BID_WeatherCalc'.
There are 0 rows in 1 pages for object "IMP_BID_WeatherCalc".
DBCC results for 'JBM_Predecessors'.
There are 0 rows in 0 pages for object "JBM_Predecessors".
DBCC results for 'TRC_POMaster'.
There are 0 rows in 0 pages for object "TRC_POMaster".
DBCC results for 'JBM_CSTakeoffPrompts'.
There are 0 rows in 0 pages for object "JBM_CSTakeoffPrompts".
DBCC results for 'GEN_AccessLevels'.
There are 3 rows in 1 pages for object "GEN_AccessLevels".
DBCC results for 'TRC_JobMessageAttachments'.
There are 0 rows in 0 pages for object "TRC_JobMessageAttachments".
DBCC results for 'JBM_TasksSubCont'.
There are 0 rows in 0 pages for object "JBM_TasksSubCont".
DBCC results for 'IMP_BidLCSubtotals'.
There are 0 rows in 11 pages for object "IMP_BidLCSubtotals".
DBCC results for 'NEC_Table_5_Groups'.
There are 592 rows in 3 pages for object "NEC_Table_5_Groups".
DBCC results for 'IMP_CSBranchData'.
There are 0 rows in 0 pages for object "IMP_CSBranchData".
DBCC results for 'JBM_CSTakeoffPrompts_Defaults'.
There are 0 rows in 0 pages for object "JBM_CSTakeoffPrompts_Defaults".
DBCC results for 'GEN_AppVersions'.
There are 3 rows in 1 pages for object "GEN_AppVersions".
DBCC results for 'TRC_JobMessageRecipients'.
There are 0 rows in 0 pages for object "TRC_JobMessageRecipients".
DBCC results for 'IMP_CSData'.
There are 0 rows in 0 pages for object "IMP_CSData".
DBCC results for 'BID_BidColumnAttrib'.
There are 935 rows in 6 pages for object "BID_BidColumnAttrib".
DBCC results for 'NEC_Table_5A'.
There are 19 rows in 1 pages for object "NEC_Table_5A".
DBCC results for 'IMP_CSDevices'.
There are 0 rows in 0 pages for object "IMP_CSDevices".
DBCC results for 'JBM_PREF'.
There are 30 rows in 1 pages for object "JBM_PREF".
DBCC results for 'JBM_CSTakeoffPrompts_Rows'.
There are 0 rows in 0 pages for object "JBM_CSTakeoffPrompts_Rows".
DBCC results for 'IMP_CSFeederData'.
There are 0 rows in 0 pages for object "IMP_CSFeederData".
DBCC results for 'GEN_Asm_Job_Group'.
There are 0 rows in 0 pages for object "GEN_Asm_Job_Group".
DBCC results for 'JBM_BidSubtotals'.
There are 8671 rows in 315 pages for object "JBM_BidSubtotals".
DBCC results for 'BID_BNAM'.
There are 9 rows in 1 pages for object "BID_BNAM".
DBCC results for 'NEC_Table_5A_Groups'.
There are 8 rows in 1 pages for object "NEC_Table_5A_Groups".
DBCC results for 'JBM_TasksSubContActuals'.
There are 0 rows in 0 pages for object "JBM_TasksSubContActuals".
DBCC results for 'IMP_CSFeeders'.
There are 0 rows in 0 pages for object "IMP_CSFeeders".
DBCC results for 'JBM_CSTempPrompts'.
There are 0 rows in 0 pages for object "JBM_CSTempPrompts".
DBCC results for 'IMP_CSFireAlarm'.
There are 0 rows in 0 pages for object "IMP_CSFireAlarm".
DBCC results for 'TRC_POReceiving'.
There are 0 rows in 0 pages for object "TRC_POReceiving".
DBCC results for 'GEN_Calendar'.
There are 0 rows in 0 pages for object "GEN_Calendar".
DBCC results for 'JBM_BKDT'.
There are 340 rows in 5 pages for object "JBM_BKDT".
DBCC results for 'NEC_Table_8'.
There are 36 rows in 1 pages for object "NEC_Table_8".
DBCC results for 'IMP_CSFixtures'.
There are 0 rows in 0 pages for object "IMP_CSFixtures".
DBCC results for 'JBM_DeviceSpec'.
There are 4 rows in 1 pages for object "JBM_DeviceSpec".
DBCC results for 'BID_BondCalc'.
There are 7 rows in 1 pages for object "BID_BondCalc".
DBCC results for 'JBM_TasksTools'.
There are 0 rows in 0 pages for object "JBM_TasksTools".
DBCC results for 'IMP_CSHVAC'.
There are 0 rows in 0 pages for object "IMP_CSHVAC".
DBCC results for 'TRC_POReceivingSlipDetail'.
There are 0 rows in 0 pages for object "TRC_POReceivingSlipDetail".
DBCC results for 'GEN_CSFeederData'.
There are 0 rows in 0 pages for object "GEN_CSFeederData".
DBCC results for 'NEC_Table_9'.
There are 21 rows in 2 pages for object "NEC_Table_9".
DBCC results for 'IMP_CSHVACData'.
There are 0 rows in 0 pages for object "IMP_CSHVACData".
DBCC results for 'JBM_Drawing_Revisions'.
There are 0 rows in 0 pages for object "JBM_Drawing_Revisions".
DBCC results for 'TRC_JobMessageResponseAttachments'.
There are 0 rows in 0 pages for object "TRC_JobMessageResponseAttachments".
DBCC results for 'NEC_Table_C1'.
There are 163 rows in 2 pages for object "NEC_Table_C1".
DBCC results for 'JBM_TasksToolsActuals'.
There are 0 rows in 0 pages for object "JBM_TasksToolsActuals".
DBCC results for 'IMP_CSLayoutCol'.
There are 0 rows in 0 pages for object "IMP_CSLayoutCol".
DBCC results for 'TRC_POReceivingSlips'.
There are 0 rows in 0 pages for object "TRC_POReceivingSlips".
DBCC results for 'TRC_JobMessageResponses'.
There are 0 rows in 0 pages for object "TRC_JobMessageResponses".
DBCC results for 'JBM_BKHY'.
There are 0 rows in 0 pages for object "JBM_BKHY".
DBCC results for 'BID_LaborAdjustCalc'.
There are 25 rows in 1 pages for object "BID_LaborAdjustCalc".
DBCC results for 'IMP_CSLayoutRow'.
There are 0 rows in 0 pages for object "IMP_CSLayoutRow".
DBCC results for 'JBM_Drawings'.
There are 0 rows in 0 pages for object "JBM_Drawings".
DBCC results for 'GEN_CSHVACData'.
There are 0 rows in 0 pages for object "GEN_CSHVACData".
DBCC results for 'NEC_Table_C10'.
There are 163 rows in 2 pages for object "NEC_Table_C10".
DBCC results for 'IMP_CSLVolt'.
There are 0 rows in 0 pages for object "IMP_CSLVolt".
DBCC results for 'TRC_POTasks'.
There are 0 rows in 0 pages for object "TRC_POTasks".
DBCC results for 'TRC_JobMessages'.
There are 0 rows in 0 pages for object "TRC_JobMessages".
DBCC results for 'JBM_TKI'.
There are 19924 rows in 890 pages for object "JBM_TKI".
DBCC results for 'IMP_CSMotorData'.
There are 0 rows in 0 pages for object "IMP_CSMotorData".
DBCC results for 'JBM_BKMT'.
There are 10 rows in 1 pages for object "JBM_BKMT".
DBCC results for 'BID_OHCalc'.
There are 31 rows in 1 pages for object "BID_OHCalc".
DBCC results for 'NEC_Table_C10A'.
There are 57 rows in 1 pages for object "NEC_Table_C10A".
DBCC results for 'ITM_Item_Field_Import_Flags'.
There are 0 rows in 0 pages for object "ITM_Item_Field_Import_Flags".
DBCC results for 'IMP_CSMotors'.
There are 0 rows in 0 pages for object "IMP_CSMotors".
DBCC results for 'TRC_Req_FieldReqs'.
There are 0 rows in 0 pages for object "TRC_Req_FieldReqs".
DBCC results for 'JBM_DropDownValues'.
There are 2430 rows in 13 pages for object "JBM_DropDownValues".
DBCC results for 'GEN_CSLayoutCol'.
There are 0 rows in 0 pages for object "GEN_CSLayoutCol".
DBCC results for 'IMP_CSResidential'.
There are 0 rows in 0 pages for object "IMP_CSResidential".
DBCC results for 'TRC_LaborFactor'.
There are 0 rows in 0 pages for object "TRC_LaborFactor".
DBCC results for 'NEC_Table_C11'.
There are 163 rows in 2 pages for object "NEC_Table_C11".
DBCC results for 'ITM_ITEMHeaders'.
There are 3897 rows in 27 pages for object "ITM_ITEMHeaders".
DBCC results for 'IMP_CSSwGear'.
There are 0 rows in 0 pages for object "IMP_CSSwGear".
DBCC results for 'TRC_ReqDetails'.
There are 0 rows in 0 pages for object "TRC_ReqDetails".
DBCC results for 'GEN_CSLayoutRow'.
There are 0 rows in 0 pages for object "GEN_CSLayoutRow".
DBCC results for 'IMP_CSSwGearData'.
There are 0 rows in 0 pages for object "IMP_CSSwGearData".
DBCC results for 'JBM_Engineers'.
There are 0 rows in 0 pages for object "JBM_Engineers".
DBCC results for 'TRC_LaborFactorAdjust'.
There are 0 rows in 0 pages for object "TRC_LaborFactorAdjust".
DBCC results for 'BID_ProfitCalc'.
There are 30 rows in 1 pages for object "BID_ProfitCalc".
DBCC results for 'NEC_Table_C11A'.
There are 57 rows in 1 pages for object "NEC_Table_C11A".
DBCC results for 'ITM_ITEMLaborLevel'.
There are 403230 rows in 1446 pages for object "ITM_ITEMLaborLevel".
DBCC results for 'IMP_CSTakeoffGroups'.
There are 0 rows in 0 pages for object "IMP_CSTakeoffGroups".
DBCC results for 'GEN_CSMotorData'.
There are 0 rows in 0 pages for object "GEN_CSMotorData".
DBCC results for 'JBM_BondCalc'.
There are 103 rows in 17 pages for object "JBM_BondCalc".
DBCC results for 'IMP_CSTakeoffList'.
There are 0 rows in 0 pages for object "IMP_CSTakeoffList".
DBCC results for 'JBM_ProfitCalc'.
There are 236 rows in 5 pages for object "JBM_ProfitCalc".
DBCC results for 'TRC_ReqDetailTasks'.
There are 0 rows in 0 pages for object "TRC_ReqDetailTasks".
DBCC results for 'JBM_Estimators'.
There are 13 rows in 1 pages for object "JBM_Estimators".
DBCC results for 'NEC_Table_C12'.
There are 134 rows in 1 pages for object "NEC_Table_C12".
DBCC results for 'ITM_ITEMVendor'.
There are 672050 rows in 6649 pages for object "ITM_ITEMVendor".
DBCC results for 'JBM_TKI_InstallCodes'.
There are 0 rows in 0 pages for object "JBM_TKI_InstallCodes".
DBCC results for 'IMP_CSTakeoffPrompts'.
There are 0 rows in 0 pages for object "IMP_CSTakeoffPrompts".
DBCC results for 'TRC_LaborInstallationDetails'.
There are 0 rows in 0 pages for object "TRC_LaborInstallationDetails".
DBCC results for 'IMP_CSUser1'.
There are 0 rows in 0 pages for object "IMP_CSUser1".
DBCC results for 'JBM_ESubContactMap'.
There are 0 rows in 0 pages for object "JBM_ESubContactMap".
DBCC results for 'GEN_CSSwGearData'.
There are 0 rows in 0 pages for object "GEN_CSSwGearData".
DBCC results for 'JBM_BranchSpec'.
There are 4 rows in 1 pages for object "JBM_BranchSpec".
DBCC results for 'BID_QES'.
There are 50 rows in 1 pages for object "BID_QES".
DBCC results for 'NEC_Table_C12A'.
There are 57 rows in 1 pages for object "NEC_Table_C12A".
DBCC results for 'JBM_TKIH'.
There are 0 rows in 0 pages for object "JBM_TKIH".
DBCC results for 'IMP_CSUser2'.
There are 0 rows in 0 pages for object "IMP_CSUser2".
DBCC results for 'JBM_ESubJobSiteMap'.
There are 0 rows in 0 pages for object "JBM_ESubJobSiteMap".
DBCC results for 'TRC_LaborInstallations'.
There are 0 rows in 0 pages for object "TRC_LaborInstallations".
DBCC results for 'ITM_ITHA'.
There are 5028 rows in 42 pages for object "ITM_ITHA".
DBCC results for 'IMP_CSUser3'.
There are 0 rows in 0 pages for object "IMP_CSUser3".
DBCC results for 'JBM_Project_Managers'.
There are 0 rows in 0 pages for object "JBM_Project_Managers".
DBCC results for 'TRC_ReqMaster'.
There are 0 rows in 0 pages for object "TRC_ReqMaster".
DBCC results for 'JBM_FBOSpec'.
There are 4 rows in 1 pages for object "JBM_FBOSpec".
DBCC results for 'JBM_Breakout_Classes'.
There are 0 rows in 0 pages for object "JBM_Breakout_Classes".
DBCC results for 'BID_QESBidAmounts'.
There are 0 rows in 0 pages for object "BID_QESBidAmounts".
DBCC results for 'NEC_Table_C1A'.
There are 57 rows in 1 pages for object "NEC_Table_C1A".
DBCC results for 'IMP_CSUser4'.
There are 0 rows in 0 pages for object "IMP_CSUser4".
DBCC results for 'GEN_CSTakeoffList'.
There are 0 rows in 0 pages for object "GEN_CSTakeoffList".
DBCC results for 'TRC_LaborInstallationSessions'.
There are 0 rows in 0 pages for object "TRC_LaborInstallationSessions".
DBCC results for 'IMP_EQIP'.
There are 0 rows in 3 pages for object "IMP_EQIP".
DBCC results for 'JBM_QES'.
There are 1466 rows in 25 pages for object "JBM_QES".
DBCC results for 'NEC_Table_C2'.
There are 163 rows in 2 pages for object "NEC_Table_C2".
DBCC results for 'JBM_TKIH_InstallCodes'.
There are 0 rows in 0 pages for object "JBM_TKIH_InstallCodes".
DBCC results for 'IMP_EXPR'.
There are 18 rows in 1 pages for object "IMP_EXPR".
DBCC results for 'GEN_CSTakeoffList_Rows'.
There are 0 rows in 0 pages for object "GEN_CSTakeoffList_Rows".
DBCC results for 'ITM_ITLB'.
There are 57 rows in 1 pages for object "ITM_ITLB".
DBCC results for 'IMP_FTEX'.
There are 689 rows in 3 pages for object "IMP_FTEX".
DBCC results for 'TRC_ReqReceiving'.
There are 0 rows in 0 pages for object "TRC_ReqReceiving".
DBCC results for 'JBM_BuildingAreaCalc'.
There are 0 rows in 0 pages for object "JBM_BuildingAreaCalc".
DBCC results for 'BID_QESBidBreakdownVendors'.
There are 0 rows in 0 pages for object "BID_QESBidBreakdownVendors".
DBCC results for 'NEC_Table_C2A'.
There are 57 rows in 1 pages for object "NEC_Table_C2A".
DBCC results for 'JBM_TkiItemPrompts'.
There are 10171 rows in 39 pages for object "JBM_TkiItemPrompts".
DBCC results for 'IMP_Inventory'.
There are 0 rows in 0 pages for object "IMP_Inventory".
DBCC results for 'GEN_CSUserTabs'.
There are 1 rows in 1 pages for object "GEN_CSUserTabs".
DBCC results for 'ITM_ITLB_ItlbAsso'.
There are 57 rows in 1 pages for object "ITM_ITLB_ItlbAsso".
DBCC results for 'JBM_QESBidAlarms'.
There are 3745 rows in 23 pages for object "JBM_QESBidAlarms".
DBCC results for 'TRC_ReqReceivingSlipDetail'.
There are 0 rows in 0 pages for object "TRC_ReqReceivingSlipDetail".
DBCC results for 'NEC_Table_C3'.
There are 163 rows in 2 pages for object "NEC_Table_C3".
DBCC results for 'JBM_TPSH'.
Msg 8928, Level 16, State 1, Line 1
Object ID 617769258, index ID 1, partition ID 72057594090815488, alloc unit ID 72057594101301248 (type In-row data): Page (1:43736) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 617769258, index ID 1, partition ID 72057594090815488, alloc unit ID 72057594101301248 (type In-row data), page (1:43736). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 617769258, index ID 1, partition ID 72057594090815488, alloc unit ID 72057594101301248 (type In-row data). Page (1:43736) was not seen in the scan although its parent (1:6735) and previous (1:42753) refer to it. Check any previous errors.
There are 2221 rows in 25 pages for object "JBM_TPSH".
CHECKDB found 0 allocation errors and 3 consistency errors in table 'JBM_TPSH' (object ID 617769258).
DBCC results for 'IMP_JBM_ASMY'.
There are 0 rows in 0 pages for object "IMP_JBM_ASMY".
DBCC results for 'GEN_DesignMasterBitmapCrossReference'.
There are 0 rows in 0 pages for object "GEN_DesignMasterBitmapCrossReference".
DBCC results for 'TRC_LaborInstallationSessions_DWR'.
There are 0 rows in 0 pages for object "TRC_LaborInstallationSessions_DWR".
DBCC results for 'ITM_ItlbAsso'.
There are 10 rows in 1 pages for object "ITM_ItlbAsso".
DBCC results for 'IMP_OutlookContacts'.
There are 0 rows in 0 pages for object "IMP_OutlookContacts".
DBCC results for 'TRC_ReqReceivingSlips'.
There are 0 rows in 0 pages for object "TRC_ReqReceivingSlips".
DBCC results for 'BID_QESBreakdown'.
There are 0 rows in 0 pages for object "BID_QESBreakdown".
DBCC results for 'NEC_Table_C3A'.
There are 57 rows in 1 pages for object "NEC_Table_C3A".
DBCC results for 'IMP_QTPH'.
There are 0 rows in 0 pages for object "IMP_QTPH".
DBCC results for 'JBM_QESBidAmounts'.
There are 375 rows in 4 pages for object "JBM_QESBidAmounts".
DBCC results for 'GEN_DropDownDefaults'.
There are 1711 rows in 9 pages for object "GEN_DropDownDefaults".
DBCC results for 'ITM_LBLV'.
There are 6 rows in 1 pages for object "ITM_LBLV".
DBCC results for 'IMP_QTSL'.
There are 0 rows in 3 pages for object "IMP_QTSL".
DBCC results for 'TRC_ReqShipping'.
There are 0 rows in 0 pages for object "TRC_ReqShipping".
DBCC results for 'TRC_LaborInstallationSessions_DWRLabor'.
There are 0 rows in 0 pages for object "TRC_LaborInstallationSessions_DWRLabor".
DBCC results for 'JBM_CADV'.
There are 0 rows in 0 pages for object "JBM_CADV".
DBCC results for 'NEC_Table_C4'.
There are 163 rows in 2 pages for object "NEC_Table_C4".
DBCC results for 'IMP_QUOT'.
There are 0 rows in 3 pages for object "IMP_QUOT".
DBCC results for 'IMP_QuoteBreakdown'.
There are 0 rows in 0 pages for object "IMP_QuoteBreakdown".
DBCC results for 'TRC_ReqShippingSlipDetail'.
There are 0 rows in 0 pages for object "TRC_ReqShippingSlipDetail".
DBCC results for 'GEN_DropDownValues'.
There are 1711 rows in 9 pages for object "GEN_DropDownValues".
DBCC results for 'JBM_CalculationSheet'.
There are 0 rows in 0 pages for object "JBM_CalculationSheet".
DBCC results for 'BID_SelectValueCalc'.
There are 0 rows in 0 pages for object "BID_SelectValueCalc".
DBCC results for 'NEC_Table_C4A'.
There are 58 rows in 1 pages for object "NEC_Table_C4A".
DBCC results for 'ITM_LCLS'.
There are 10 rows in 1 pages for object "ITM_LCLS".
DBCC results for 'IMP_QuoteLots'.
There are 0 rows in 0 pages for object "IMP_QuoteLots".
DBCC results for 'IMP_SBCN'.
There are 0 rows in 3 pages for object "IMP_SBCN".
DBCC results for 'JBM_QESBidBreakdown'.
There are 0 rows in 0 pages for object "JBM_QESBidBreakdown".
DBCC results for 'TRC_ReqShippingSlips'.
There are 0 rows in 0 pages for object "TRC_ReqShippingSlips".
DBCC results for 'JBM_Calendar'.
There are 0 rows in 0 pages for object "JBM_Calendar".
DBCC results for 'NEC_Table_C5'.
There are 163 rows in 2 pages for object "NEC_Table_C5".
DBCC results for 'ITM_PriceUpdate'.
There are 0 rows in 0 pages for object "ITM_PriceUpdate".
DBCC results for 'JBM_VARB'.
There are 0 rows in 0 pages for object "JBM_VARB".
DBCC results for 'IMP_SBFT'.
There are 1141 rows in 17 pages for object "IMP_SBFT".
DBCC results for 'GEN_DropDownValueTypes'.
There are 206 rows in 1 pages for object "GEN_DropDownValueTypes".
DBCC results for 'IMP_SBGP'.
There are 50 rows in 6 pages for object "IMP_SBGP".
DBCC results for 'TRC_RFQDetails'.
There are 0 rows in 0 pages for object "TRC_RFQDetails".
DBCC results for 'JBM_GridColumnAttrib'.
There are 0 rows in 0 pages for object "JBM_GridColumnAttrib".
DBCC results for 'JBM_CompHistory'.
There are 0 rows in 0 pages for object "JBM_CompHistory".
DBCC results for 'BID_STDCALC'.
There are 7930 rows in 83 pages for object "BID_STDCALC".
DBCC results for 'NEC_Table_C5A'.
There are 58 rows in 1 pages for object "NEC_Table_C5A".
DBCC results for 'ITM_QuoteVendorSubtotals'.
There are 0 rows in 0 pages for object "ITM_QuoteVendorSubtotals".
DBCC results for 'JBM_VerifyMasterItemsWork'.
There are 0 rows in 0 pages for object "JBM_VerifyMasterItemsWork".
DBCC results for 'IMP_STDCALC'.
There are 0 rows in 49 pages for object "IMP_STDCALC".
DBCC results for 'GEN_EmailProfiles'.
There are 1 rows in 1 pages for object "GEN_EmailProfiles".
DBCC results for 'IMP_SUBH'.
There are 0 rows in 0 pages for object "IMP_SUBH".
DBCC results for 'JBM_QESBidBreakdownVendors'.
There are 0 rows in 0 pages for object "JBM_QESBidBreakdownVendors".
DBCC results for 'JBM_JBMT'.
There are 30 rows in 3 pages for object "JBM_JBMT".
DBCC results for 'NEC_Table_C6'.
There are 163 rows in 2 pages for object "NEC_Table_C6".
DBCC results for 'ITM_SUBT'.
There are 299 rows in 2 pages for object "ITM_SUBT".
DBCC results for 'IMP_SUBHLabor'.
There are 0 rows in 0 pages for object "IMP_SUBHLabor".
DBCC results for 'TRC_LaborInstallationSessionsSubtotals'.
There are 0 rows in 0 pages for object "TRC_LaborInstallationSessionsSubtotals".
DBCC results for 'JBM_CSBranchData'.
There are 0 rows in 0 pages for object "JBM_CSBranchData".
DBCC results for 'BID_TPSH'.
There are 276 rows in 2 pages for object "BID_TPSH".
DBCC results for 'JBM_WeatherCalc'.
There are 117 rows in 1 pages for object "JBM_WeatherCalc".
DBCC results for 'IMP_TKI'.
There are 0 rows in 188 pages for object "IMP_TKI".
DBCC results for 'NEC_Table_C6A'.
There are 57 rows in 1 pages for object "NEC_Table_C6A".
DBCC results for 'ITM_TraSer_Clipboard'.
There are 1 rows in 1 pages for object "ITM_TraSer_Clipboard".
DBCC results for 'IMP_TkiItemPrompts'.
There are 0 rows in 10 pages for object "IMP_TkiItemPrompts".
DBCC results for 'BID_WeatherCalc'.
There are 22 rows in 1 pages for object "BID_WeatherCalc".
DBCC results for 'ITM_VARB'.
There are 699 rows in 3 pages for object "ITM_VARB".
DBCC results for 'IMP_Traser'.
There are 0 rows in 0 pages for object "IMP_Traser".
DBCC results for 'JBM_QESComponentSelections'.
There are 3545 rows in 17 pages for object "JBM_QESComponentSelections".
DBCC results for 'TRC_RFQMaster'.
There are 0 rows in 0 pages for object "TRC_RFQMaster".
DBCC results for 'TRC_LaborRES'.
There are 0 rows in 0 pages for object "TRC_LaborRES".
DBCC results for 'NEC_Table_C7'.
There are 163 rows in 2 pages for object "NEC_Table_C7".
DBCC results for 'NEC_CATable_Groups'.
There are 152 rows in 1 pages for object "NEC_CATable_Groups".
DBCC results for 'IMP_VARB'.
There are 0 rows in 0 pages for object "IMP_VARB".
DBCC results for 'GEN_eSubRLL'.
There are 0 rows in 0 pages for object "GEN_eSubRLL".
DBCC results for 'INV_ITEM'.
There are 1 rows in 1 pages for object "INV_ITEM".
DBCC results for 'GEN_FBOSpec'.
There are 0 rows in 0 pages for object "GEN_FBOSpec".
DBCC results for 'JBM_CSBranchData_CircuitDetailMembers'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitDetailMembers".
DBCC results for 'COM_Companies'.
There are 115 rows in 1 pages for object "COM_Companies".
DBCC results for 'NEC_Table_C7A'.
There are 57 rows in 1 pages for object "NEC_Table_C7A".
DBCC results for 'NEC_Conductor_Applications'.
There are 39 rows in 1 pages for object "NEC_Conductor_Applications".
DBCC results for 'JBM_RLL_LaborValues'.
There are 10 rows in 1 pages for object "JBM_RLL_LaborValues".
DBCC results for 'TRC_SubmittalDetails'.
There are 0 rows in 0 pages for object "TRC_SubmittalDetails".
DBCC results for 'ITM_VEND'.
There are 124 rows in 1 pages for object "ITM_VEND".
DBCC results for 'INV_ITEMLocations'.
There are 0 rows in 0 pages for object "INV_ITEMLocations".
DBCC results for 'JBM_CSBranchData_CircuitDetails'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitDetails".
DBCC results for 'NEC_Table_C8'.
There are 163 rows in 2 pages for object "NEC_Table_C8".
DBCC results for 'NEC_Conductor_Types'.
There are 29 rows in 1 pages for object "NEC_Conductor_Types".
DBCC results for 'JBM_SBPH'.
There are 2219 rows in 39 pages for object "JBM_SBPH".
DBCC results for 'TRC_Submittals'.
There are 0 rows in 0 pages for object "TRC_Submittals".
DBCC results for 'NEC_Table_C8A'.
There are 57 rows in 1 pages for object "NEC_Table_C8A".
DBCC results for 'NEC_Conduit_Types'.
There are 13 rows in 1 pages for object "NEC_Conduit_Types".
DBCC results for 'JBM_SBPHLabor'.
There are 2219 rows in 26 pages for object "JBM_SBPHLabor".
DBCC results for 'JBM_CSBranchData_CircuitDetailsTakeoffGroups'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitDetailsTakeoffGroups".
DBCC results for 'COM_CompTypes'.
There are 115 rows in 1 pages for object "COM_CompTypes".
DBCC results for 'JBM_AcceptedApplications'.
There are 0 rows in 0 pages for object "JBM_AcceptedApplications".
DBCC results for 'INV_Locations'.
There are 0 rows in 0 pages for object "INV_Locations".
DBCC results for 'TRC_LaborSkills'.
There are 0 rows in 0 pages for object "TRC_LaborSkills".
DBCC results for 'NEC_Table_C9'.
There are 163 rows in 2 pages for object "NEC_Table_C9".
DBCC results for 'NEC_Conduits'.
There are 3 rows in 1 pages for object "NEC_Conduits".
DBCC results for 'JBM_SchedValues'.
There are 0 rows in 0 pages for object "JBM_SchedValues".
DBCC results for 'COM_ContactAddresses'.
There are 198 rows in 1 pages for object "COM_ContactAddresses".
DBCC results for 'JBM_Addenda'.
There are 0 rows in 0 pages for object "JBM_Addenda".
DBCC results for 'INV_ManCat'.
There are 1 rows in 1 pages for object "INV_ManCat".
DBCC results for 'JBM_CSBranchData_CircuitDetailsTakeoffList'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitDetailsTakeoffList".
DBCC results for 'NEC_Table_C9A'.
There are 57 rows in 1 pages for object "NEC_Table_C9A".
DBCC results for 'NEC_ConduitsRelationTable'.
There are 13 rows in 2 pages for object "NEC_ConduitsRelationTable".
DBCC results for 'TRC_SubmittalTemplate'.
There are 0 rows in 0 pages for object "TRC_SubmittalTemplate".
DBCC results for 'JBM_Addenda_Drawings'.
There are 0 rows in 0 pages for object "JBM_Addenda_Drawings".
DBCC results for 'NEC_CorrectionFactors'.
There are 16 rows in 1 pages for object "NEC_CorrectionFactors".
DBCC results for 'JBM_CSBranchData_CircuitDetailsTakeoffPrompts'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitDetailsTakeoffPrompts".
DBCC results for 'NEC_WireMaxSize'.
There are 96 rows in 2 pages for object "NEC_WireMaxSize".
DBCC results for 'TRC_TemplateCodes'.
There are 38 rows in 2 pages for object "TRC_TemplateCodes".
DBCC results for 'COM_ContactEmailAddresses'.
There are 1 rows in 1 pages for object "COM_ContactEmailAddresses".
DBCC results for 'SUB_EXPR'.
There are 18 rows in 1 pages for object "SUB_EXPR".
DBCC results for 'JBM_Alternate_Classes'.
There are 0 rows in 0 pages for object "JBM_Alternate_Classes".
DBCC results for 'NEC_CorrectionFactors1819'.
There are 75 rows in 1 pages for object "NEC_CorrectionFactors1819".
DBCC results for 'INV_Reconcile'.
There are 0 rows in 0 pages for object "INV_Reconcile".
DBCC results for 'JBM_CSBranchData_CircuitSummary'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitSummary".
DBCC results for 'SUB_FTEX'.
There are 640 rows in 3 pages for object "SUB_FTEX".
DBCC results for 'NEC_CTable_Groups'.
There are 608 rows in 3 pages for object "NEC_CTable_Groups".
DBCC results for 'INV_ReconcileDetail'.
There are 0 rows in 0 pages for object "INV_ReconcileDetail".
DBCC results for 'TRC_TimeCard'.
There are 0 rows in 0 pages for object "TRC_TimeCard".
DBCC results for 'GEN_Feature'.
There are 69 rows in 1 pages for object "GEN_Feature".
DBCC results for 'SUB_SBFT'.
There are 1141 rows in 10 pages for object "SUB_SBFT".
DBCC results for 'NEC_MaxTempAllowed'.
There are 54 rows in 2 pages for object "NEC_MaxTempAllowed".
DBCC results for 'INV_StockNumberTEMP'.
There are 0 rows in 0 pages for object "INV_StockNumberTEMP".
DBCC results for 'JBM_CSBranchData_CircuitSummary_ByPanel'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitSummary_ByPanel".
DBCC results for 'COM_ContactPhoneNumbers'.
There are 165 rows in 1 pages for object "COM_ContactPhoneNumbers".
DBCC results for 'NEC_NEMA_SIZE_STARTERS'.
There are 169 rows in 2 pages for object "NEC_NEMA_SIZE_STARTERS".
DBCC results for 'GEN_FeatureLinks'.
There are 0 rows in 0 pages for object "GEN_FeatureLinks".
DBCC results for 'JBM_AppForPayment'.
There are 0 rows in 0 pages for object "JBM_AppForPayment".
DBCC results for 'INV_Transfers'.
There are 0 rows in 0 pages for object "INV_Transfers".
DBCC results for 'COM_Contacts'.
There are 198 rows in 3 pages for object "COM_Contacts".
DBCC results for 'SUB_SBGP'.
There are 50 rows in 12 pages for object "SUB_SBGP".
DBCC results for 'NEC_Phase'.
There are 4 rows in 1 pages for object "NEC_Phase".
DBCC results for 'GEN_GridColumns'.
There are 1910 rows in 33 pages for object "GEN_GridColumns".
DBCC results for 'TRC_LaborSkills_OldRates'.
There are 0 rows in 0 pages for object "TRC_LaborSkills_OldRates".
DBCC results for 'TRC_Tool_IDs'.
There are 0 rows in 0 pages for object "TRC_Tool_IDs".
DBCC results for 'JBM_CSBranchData_CircuitSummary_ByPanel_TakeoffGroups'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitSummary_ByPanel_TakeoffGroups".
DBCC results for 'NEC_Recommended_Wireway_size'.
There are 7 rows in 2 pages for object "NEC_Recommended_Wireway_size".
DBCC results for 'INV_VendorReturn'.
There are 0 rows in 0 pages for object "INV_VendorReturn".
DBCC results for 'NEC_SAFETY_SWITCHES'.
There are 44 rows in 1 pages for object "NEC_SAFETY_SWITCHES".
DBCC results for 'TRC_DefaultMessageTemplates'.
There are 6 rows in 1 pages for object "TRC_DefaultMessageTemplates".
DBCC results for 'JBM_SelectValueCalc'.
There are 0 rows in 0 pages for object "JBM_SelectValueCalc".
DBCC results for 'GEN_Holidays'.
There are 0 rows in 0 pages for object "GEN_Holidays".
DBCC results for 'JBM_CSBranchData_CircuitSummary_ByPanel_TakeoffList'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitSummary_ByPanel_TakeoffList".
DBCC results for 'NEC_Starter_Types'.
There are 6 rows in 1 pages for object "NEC_Starter_Types".
DBCC results for 'TRC_ToolsRES'.
There are 0 rows in 0 pages for object "TRC_ToolsRES".
DBCC results for 'COM_FeatureAccess'.
There are 207 rows in 2 pages for object "COM_FeatureAccess".
DBCC results for 'ITM_Asm_Group'.
There are 1 rows in 1 pages for object "ITM_Asm_Group".
DBCC results for 'GEN_ImportMappings'.
There are 0 rows in 0 pages for object "GEN_ImportMappings".
DBCC results for 'JBM_CSBranchData_CircuitSummary_ByPanel_TakeoffPrompts'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitSummary_ByPanel_TakeoffPrompts".
DBCC results for 'NEC_Table_11a'.
There are 6 rows in 1 pages for object "NEC_Table_11a".
DBCC results for 'ITM_Asm_Group_Detail'.
There are 0 rows in 0 pages for object "ITM_Asm_Group_Detail".
DBCC results for 'JBM_ServiceDistSpec'.
There are 4 rows in 1 pages for object "JBM_ServiceDistSpec".
DBCC results for 'GEN_ImportVendorData'.
There are 0 rows in 0 pages for object "GEN_ImportVendorData".
DBCC results for 'JBM_CSBranchData_CircuitSummaryTakeoffGroups_ByPanel_Col'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitSummaryTakeoffGroups_ByPanel_Col".
DBCC results for 'NEC_Table_11b'.
There are 6 rows in 1 pages for object "NEC_Table_11b".
DBCC results for 'JBM_ApplicationCompTypes'.
There are 0 rows in 0 pages for object "JBM_ApplicationCompTypes".
DBCC results for 'ITM_Asm_Group_Detail_InstallCodes'.
There are 0 rows in 0 pages for object "ITM_Asm_Group_Detail_InstallCodes".
DBCC results for 'JBM_SPIT'.
There are 741 rows in 22 pages for object "JBM_SPIT".
DBCC results for 'GEN_SCAL'.
There are 113 rows in 2 pages for object "GEN_SCAL".
DBCC results for 'GEN_InstallationSubtotalGroupDetails'.
There are 0 rows in 0 pages for object "GEN_InstallationSubtotalGroupDetails".
DBCC results for 'COM_LastOpenPhase'.
There are 20 rows in 1 pages for object "COM_LastOpenPhase".
DBCC results for 'NEC_Table_12a'.
There are 6 rows in 1 pages for object "NEC_Table_12a".
DBCC results for 'GEN_SentVia'.
There are 13 rows in 1 pages for object "GEN_SentVia".
DBCC results for 'JBM_CSBranchData_CircuitSummaryTakeoffPrompts_ByPanel_Col'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CircuitSummaryTakeoffPrompts_ByPanel_Col".
DBCC results for 'JBM_Asm_Job_Group'.
There are 0 rows in 0 pages for object "JBM_Asm_Job_Group".
DBCC results for 'ITM_ASM_MASTER_GROUP_NAMES'.
There are 0 rows in 0 pages for object "ITM_ASM_MASTER_GROUP_NAMES".
DBCC results for 'TRC_TransmittalDetail'.
There are 0 rows in 0 pages for object "TRC_TransmittalDetail".
DBCC results for 'TRC_LaborSkills_PendingChanges'.
There are 0 rows in 0 pages for object "TRC_LaborSkills_PendingChanges".
DBCC results for 'COM_PREF'.
There are 5 rows in 1 pages for object "COM_PREF".
DBCC results for 'NEC_Table_12b'.
There are 6 rows in 1 pages for object "NEC_Table_12b".
DBCC results for 'GEN_Skill'.
There are 16 rows in 1 pages for object "GEN_Skill".
DBCC results for 'GEN_InstallationSubtotalGroups'.
There are 0 rows in 0 pages for object "GEN_InstallationSubtotalGroups".
DBCC results for 'JBM_CSBranchData_ColumnCounts'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_ColumnCounts".
DBCC results for 'JBM_ASMY'.
There are 0 rows in 0 pages for object "JBM_ASMY".
DBCC results for 'ITM_ASM_MASTER_GROUP_OPTIONS'.
There are 0 rows in 0 pages for object "ITM_ASM_MASTER_GROUP_OPTIONS".
DBCC results for 'JBM_SPITHeaders'.
There are 274 rows in 2 pages for object "JBM_SPITHeaders".
DBCC results for 'NEC_Table_220_18'.
There are 60 rows in 2 pages for object "NEC_Table_220_18".
DBCC results for 'ZZZ_IndexDefragLog'.
There are 0 rows in 0 pages for object "ZZZ_IndexDefragLog".
DBCC results for 'GEN_InUsePhases'.
There are 0 rows in 0 pages for object "GEN_InUsePhases".
DBCC results for 'JBM_CSBranchData_ColumnCounts_ByPanel'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_ColumnCounts_ByPanel".
DBCC results for 'DWR_Accidents'.
There are 0 rows in 0 pages for object "DWR_Accidents".
DBCC results for 'NEC_Table_220_19'.
There are 30 rows in 2 pages for object "NEC_Table_220_19".
DBCC results for 'ITM_ASM_MASTER_GROUP_PRESETS'.
There are 0 rows in 0 pages for object "ITM_ASM_MASTER_GROUP_PRESETS".
DBCC results for 'JBM_STDCALC'.
There are 51680 rows in 587 pages for object "JBM_STDCALC".
DBCC results for 'JBM_BCMPColumns'.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1463676262, index ID 2, partition ID 72057594068598784, alloc unit ID 72057594076463104 (type In-row data). Page (1:43683) is missing a reference from previous page (1:43685). Possible chain linkage problem.
Msg 8928, Level 16, State 1, Line 1
Object ID 1463676262, index ID 2, partition ID 72057594068598784, alloc unit ID 72057594076463104 (type In-row data): Page (1:43685) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1463676262, index ID 2, partition ID 72057594068598784, alloc unit ID 72057594076463104 (type In-row data), page (1:43685). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1463676262, index ID 2, partition ID 72057594068598784, alloc unit ID 72057594076463104 (type In-row data). Page (1:43685) was not seen in the scan although its parent (1:44763) and previous (1:43686) refer to it. Check any previous errors.
There are 155062 rows in 1732 pages for object "JBM_BCMPColumns".
CHECKDB found 0 allocation errors and 4 consistency errors in table 'JBM_BCMPColumns' (object ID 1463676262).
DBCC results for 'NEC_Table_220_20'.
There are 6 rows in 2 pages for object "NEC_Table_220_20".
DBCC results for 'GEN_InUseTracking'.
There are 0 rows in 8 pages for object "GEN_InUseTracking".
DBCC results for 'JBM_CSBranchData_Columns'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_Columns".
DBCC results for 'NEC_Table_220_2a'.
There are 7 rows in 2 pages for object "NEC_Table_220_2a".
DBCC results for 'GEN_PHAS'.
There are 19 rows in 1 pages for object "GEN_PHAS".
DBCC results for 'DWR_Comm'.
There are 0 rows in 0 pages for object "DWR_Comm".
DBCC results for 'JBM_BCMPDependencies'.
There are 76375 rows in 229 pages for object "JBM_BCMPDependencies".
DBCC results for 'NEC_Table_220_3_a'.
There are 21 rows in 2 pages for object "NEC_Table_220_3_a".
DBCC results for 'JBM_SUBH'.
There are 0 rows in 0 pages for object "JBM_SUBH".
DBCC results for 'NEC_Table_220_3a'.
There are 24 rows in 2 pages for object "NEC_Table_220_3a".
DBCC results for 'ITM_Assembly'.
There are 71435 rows in 654 pages for object "ITM_Assembly".
DBCC results for 'JBM_CSBranchData_CombinedCircuitMembers'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CombinedCircuitMembers".
DBCC results for 'DWR_DailyWorkReport'.
There are 0 rows in 0 pages for object "DWR_DailyWorkReport".
DBCC results for 'JBM_BDPH'.
There are 923 rows in 17 pages for object "JBM_BDPH".
DBCC results for 'NEC_Table_240_6'.
There are 37 rows in 1 pages for object "NEC_Table_240_6".
DBCC results for 'JBM_SUBHLabor'.
There are 0 rows in 0 pages for object "JBM_SUBHLabor".
DBCC results for 'GEN_PhaseDefaultJobSettings'.
There are 0 rows in 0 pages for object "GEN_PhaseDefaultJobSettings".
DBCC results for 'DWR_Deficiencies'.
There are 0 rows in 0 pages for object "DWR_Deficiencies".
DBCC results for 'NEC_Table_250_122'.
There are 19 rows in 1 pages for object "NEC_Table_250_122".
DBCC results for 'JBM_Summary'.
There are 9494 rows in 386 pages for object "JBM_Summary".
DBCC results for 'GEN_PREF'.
There are 1 rows in 1 pages for object "GEN_PREF".
DBCC results for 'JBM_CSBranchData_CombinedCircuits'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_CombinedCircuits".
DBCC results for 'TRC_LaborTimeOffRanges'.
There are 0 rows in 0 pages for object "TRC_LaborTimeOffRanges".
DBCC results for 'DWR_InspectTesting'.
There are 0 rows in 0 pages for object "DWR_InspectTesting".
DBCC results for 'NEC_Table_250_66'.
There are 10 rows in 2 pages for object "NEC_Table_250_66".
DBCC results for 'ITM_AUTO_LFACT'.
There are 102 rows in 1 pages for object "ITM_AUTO_LFACT".
DBCC results for 'JBM_Summary_FrozenBids'.
There are 0 rows in 0 pages for object "JBM_Summary_FrozenBids".
DBCC results for 'JBM_CSBranchData_TakeoffGroups'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_TakeoffGroups".
DBCC results for 'NEC_Table_310_15B2a'.
There are 6 rows in 1 pages for object "NEC_Table_310_15B2a".
DBCC results for 'GEN_Skill_PendingChanges'.
There are 16 rows in 1 pages for object "GEN_Skill_PendingChanges".
DBCC results for 'TRC_MeetingMinutes'.
There are 0 rows in 0 pages for object "TRC_MeetingMinutes".
DBCC results for 'DWR_IssueLaborDelays'.
There are 0 rows in 0 pages for object "DWR_IssueLaborDelays".
DBCC results for 'ITM_CATL'.
There are 721 rows in 5 pages for object "ITM_CATL".
DBCC results for 'JBM_SummaryCSTC'.
There are 11988 rows in 37 pages for object "JBM_SummaryCSTC".
DBCC results for 'NEC_Table_310_15b6'.
There are 11 rows in 1 pages for object "NEC_Table_310_15b6".
DBCC results for 'TRC_MessageTemplates'.
There are 6 rows in 1 pages for object "TRC_MessageTemplates".
DBCC results for 'JBM_CSBranchData_TakeoffList'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_TakeoffList".
DBCC results for 'DWR_Issues'.
There are 0 rows in 0 pages for object "DWR_Issues".
DBCC results for 'JBM_SummaryPHAS'.
There are 19 rows in 1 pages for object "JBM_SummaryPHAS".
DBCC results for 'TRC_Deficiencies'.
There are 0 rows in 0 pages for object "TRC_Deficiencies".
DBCC results for 'NEC_Table_310_16'.
There are 30 rows in 1 pages for object "NEC_Table_310_16".
DBCC results for 'ITM_CostCodeCfgItems'.
There are 2 rows in 1 pages for object "ITM_CostCodeCfgItems".
DBCC results for 'JBM_CSBranchData_TakeoffPrompts'.
There are 0 rows in 0 pages for object "JBM_CSBranchData_TakeoffPrompts".
DBCC results for 'JBM_Tasks'.
There are 31 rows in 1 pages for object "JBM_Tasks".
DBCC results for 'DWR_IssueSubContDelays'.
There are 0 rows in 0 pages for object "DWR_IssueSubContDelays".
DBCC results for 'TRC_FieldReqDetailTasks'.
There are 0 rows in 0 pages for object "TRC_FieldReqDetailTasks".
DBCC results for 'NEC_Table_310_17'.
There are 30 rows in 1 pages for object "NEC_Table_310_17".
DBCC results for 'JBM_CSFeederData'.
There are 0 rows in 0 pages for object "JBM_CSFeederData".
DBCC results for 'ITM_CostCodeConfig'.
There are 1 rows in 1 pages for object "ITM_CostCodeConfig".
DBCC results for 'DWR_IssueToolsDelays'.
There are 0 rows in 0 pages for object "DWR_IssueToolsDelays".
DBCC results for 'NEC_Table_310_18'.
There are 13 rows in 1 pages for object "NEC_Table_310_18".
DBCC results for 'JBM_JobAddresses'.
There are 46 rows in 1 pages for object "JBM_JobAddresses".
DBCC results for 'ITM_CSTC'.
There are 999 rows in 6 pages for object "ITM_CSTC".
DBCC results for 'JBM_CSGeneric'.
There are 0 rows in 0 pages for object "JBM_CSGeneric".
DBCC results for 'DWR_LaborActivities'.
There are 1 rows in 1 pages for object "DWR_LaborActivities".
DBCC results for 'NEC_Table_310_19'.
There are 13 rows in 1 pages for object "NEC_Table_310_19".
DBCC results for 'TRC_FieldReqDetailTasks_ReqTransfers'.
There are 0 rows in 0 pages for object "TRC_FieldReqDetailTasks_ReqTransfers".
DBCC results for 'ITM_CTGY'.
There are 899 rows in 5 pages for object "ITM_CTGY".
DBCC results for 'JBM_JobCloseOut'.
There are 0 rows in 0 pages for object "JBM_JobCloseOut".
DBCC results for 'JBM_CSHVACData'.
There are 0 rows in 0 pages for object "JBM_CSHVACData".
DBCC results for 'JBM_BFCT'.
There are 22126 rows in 276 pages for object "JBM_BFCT".
DBCC results for 'NEC_Table_370_16a'.
There are 24 rows in 1 pages for object "NEC_Table_370_16a".
DBCC results for 'GEN_UserSettings'.
There are 93 rows in 1 pages for object "GEN_UserSettings".
DBCC results for 'ITM_DATB'.
There are 9 rows in 1 pages for object "ITM_DATB".
DBCC results for 'JBM_JobContacts'.
There are 65 rows in 1 pages for object "JBM_JobContacts".
DBCC results for 'DWR_LaborActivities_DailyDetails'.
There are 0 rows in 0 pages for object "DWR_LaborActivities_DailyDetails".
DBCC results for 'TRC_FieldReqInventoryReq_Temp'.
There are 0 rows in 0 pages for object "TRC_FieldReqInventoryReq_Temp".
DBCC results for 'NEC_Table_370_16a_Group'.
There are 24 rows in 1 pages for object "NEC_Table_370_16a_Group".
DBCC results for 'GEN_VARB'.
There are 0 rows in 0 pages for object "GEN_VARB".
DBCC results for 'JBM_CSLayoutCol'.
There are 0 rows in 0 pages for object "JBM_CSLayoutCol".
DBCC results for 'ITM_FORM'.
There are 1004 rows in 4 pages for object "ITM_FORM".
DBCC results for 'TRC_FieldReqMaster'.
There are 0 rows in 0 pages for object "TRC_FieldReqMaster".
DBCC results for 'NEC_Table_4'.
There are 114 rows in 1 pages for object "NEC_Table_4".
DBCC results for 'GEN_WeatherCalcValues'.
There are 91 rows in 1 pages for object "GEN_WeatherCalcValues".
DBCC results for 'DWR_Material'.
There are 0 rows in 0 pages for object "DWR_Material".
DBCC results for 'ITM_FORMCategories'.
There are 1 rows in 1 pages for object "ITM_FORMCategories".
DBCC results for 'JBM_JobUsers'.
There are 57 rows in 1 pages for object "JBM_JobUsers".
DBCC results for 'NEC_Table_430_147'.
There are 23 rows in 1 pages for object "NEC_Table_430_147".
DBCC results for 'IMP_ASM_JOB_GROUP'.
There are 0 rows in 0 pages for object "IMP_ASM_JOB_GROUP".
DBCC results for 'JBM_CSLayoutRow'.
There are 0 rows in 0 pages for object "JBM_CSLayoutRow".
DBCC results for 'DWR_Weather'.
There are 0 rows in 0 pages for object "DWR_Weather".
DBCC results for 'ITM_FORMCategory_Links'.
There are 1004 rows in 3 pages for object "ITM_FORMCategory_Links".
DBCC results for 'IMP_ASM_JOB_GROUP_DETAIL'.
There are 0 rows in 0 pages for object "IMP_ASM_JOB_GROUP_DETAIL".
DBCC results for 'TRC_InspectTesting'.
There are 0 rows in 0 pages for object "TRC_InspectTesting".
DBCC results for 'JBM_Bid_Classes'.
There are 0 rows in 0 pages for object "JBM_Bid_Classes".
DBCC results for 'NEC_Table_430_148'.
There are 12 rows in 2 pages for object "NEC_Table_430_148".
DBCC results for 'IMP_ASMYImport'.
There are 0 rows in 0 pages for object "IMP_ASMYImport".
DBCC results for 'JBM_LaborAdjustCalc'.
There are 117 rows in 5 pages for object "JBM_LaborAdjustCalc".
DBCC results for 'NEC_Table_430_149'.
There are 21 rows in 1 pages for object "NEC_Table_430_149".
DBCC results for 'ITM_InstallCodeGroups'.
There are 0 rows in 0 pages for object "ITM_InstallCodeGroups".
DBCC results for 'JBM_CSLibraryDefaults'.
There are 0 rows in 0 pages for object "JBM_CSLibraryDefaults".
DBCC results for 'TRC_InspectTesting_Retests'.
There are 0 rows in 0 pages for object "TRC_InspectTesting_Retests".
DBCC results for 'JBM_BidColumnAttrib'.
There are 4757 rows in 27 pages for object "JBM_BidColumnAttrib".
DBCC results for 'NEC_Table_430_150'.
There are 27 rows in 2 pages for object "NEC_Table_430_150".
DBCC results for 'JBM_OHCalc'.
There are 240 rows in 5 pages for object "JBM_OHCalc".
DBCC results for 'JBM_CSMotorData'.
There are 0 rows in 0 pages for object "JBM_CSMotorData".
DBCC results for 'FRM_Coef_of_Utilization'.
There are 5040 rows in 27 pages for object "FRM_Coef_of_Utilization".
DBCC results for 'TRC_IssueLaborDelays'.
There are 0 rows in 0 pages for object "TRC_IssueLaborDelays".
DBCC results for 'JBM_BidHistory'.
There are 0 rows in 0 pages for object "JBM_BidHistory".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'NEC_Table_430_151A'.
There are 9 rows in 1 pages for object "NEC_Table_430_151A".
DBCC results for 'ITM_InstallCodes'.
There are 0 rows in 0 pages for object "ITM_InstallCodes".
DBCC results for 'FRM_Effective_Reflectance'.
There are 1050 rows in 6 pages for object "FRM_Effective_Reflectance".
DBCC results for 'JBM_TasksLabor'.
There are 0 rows in 0 pages for object "JBM_TasksLabor".
DBCC results for 'FRM_Fixtures'.
There are 0 rows in 0 pages for object "FRM_Fixtures".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'NEC_Table_430_151B'.
There are 27 rows in 1 pages for object "NEC_Table_430_151B".
DBCC results for 'ITM_ITEM'.
There are 67206 rows in 1551 pages for object "ITM_ITEM".
DBCC results for 'IMP_BCMPColumns'.
There are 0 rows in 57 pages for object "IMP_BCMPColumns".
DBCC results for 'JBM_CSSwGearData'.
There are 0 rows in 0 pages for object "JBM_CSSwGearData".
DBCC results for 'FRM_Floor_Cavity_Ref_CU_Factors'.
There are 120 rows in 2 pages for object "FRM_Floor_Cavity_Ref_CU_Factors".
DBCC results for 'TRC_IssueRFI'.
There are 0 rows in 0 pages for object "TRC_IssueRFI".
DBCC results for 'IMP_BDPH'.
There are 0 rows in 3 pages for object "IMP_BDPH".
DBCC results for 'JBM_OthEquipSpec'.
There are 4 rows in 1 pages for object "JBM_OthEquipSpec".
DBCC results for 'FRM_Lamp_Categories'.
There are 6 rows in 2 pages for object "FRM_Lamp_Categories".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'NEC_Table_430_152'.
There are 7 rows in 2 pages for object "NEC_Table_430_152".
DBCC results for 'IMP_BFCT'.
There are 0 rows in 23 pages for object "IMP_BFCT".
DBCC results for 'TRC_PayPeriod'.
There are 0 rows in 0 pages for object "TRC_PayPeriod".
DBCC results for 'FRM_Lamps'.
There are 108 rows in 3 pages for object "FRM_Lamps".
DBCC results for 'BID_BcmpClass'.
There are 61 rows in 1 pages for object "BID_BcmpClass".
DBCC results for 'NEC_Table_430_152_Group'.
There are 7 rows in 2 pages for object "NEC_Table_430_152_Group".
DBCC results for 'JBM_TasksLaborActuals'.
There are 0 rows in 0 pages for object "JBM_TasksLaborActuals".
DBCC results for 'IMP_BID_BCMP'.
There are 0 rows in 3 pages for object "IMP_BID_BCMP".
DBCC results for 'JBM_CSSwGearData_Mfg'.
There are 0 rows in 0 pages for object "JBM_CSSwGearData_Mfg".
DBCC results for 'FRM_Light_Loss_Factors'.
There are 30 rows in 2 pages for object "FRM_Light_Loss_Factors".
DBCC results for 'TRC_Issues'.
There are 0 rows in 0 pages for object "TRC_Issues".
DBCC results for 'JBM_BidLCSubtotals'.
There are 11960 rows in 153 pages for object "JBM_BidLCSubtotals".
DBCC results for 'NEC_Table_430_22b'.
There are 15 rows in 2 pages for object "NEC_Table_430_22b".
DBCC results for 'IMP_BID_BCMPColumns'.
There are 0 rows in 47 pages for object "IMP_BID_BCMPColumns".
DBCC results for 'JBM_OthSystemSpec'.
There are 24 rows in 1 pages for object "JBM_OthSystemSpec".
DBCC results for 'TRC_PO_FieldReqs'.
There are 0 rows in 0 pages for object "TRC_PO_FieldReqs".
DBCC results for 'FRM_Lighting'.
There are 0 rows in 0 pages for object "FRM_Lighting".
DBCC results for 'BID_BcmpClassAttributes'.
There are 2643 rows in 17 pages for object "BID_BcmpClassAttributes".
DBCC results for 'NEC_Table_5'.
There are 158 rows in 1 pages for object "NEC_Table_5".
DBCC results for 'IMP_BID_BFCT'.
There are 0 rows in 3 pages for object "IMP_BID_BFCT".
DBCC results for 'JBM_CSTakeoffGroups'.
There are 0 rows in 0 pages for object "JBM_CSTakeoffGroups".
DBCC results for 'FRM_Luminaire_Dirt_Depreciation'.
There are 36 rows in 2 pages for object "FRM_Luminaire_Dirt_Depreciation".
DBCC results for 'TRC_IssuesBICHistory'.
There are 0 rows in 0 pages for object "TRC_IssuesBICHistory".
DBCC results for 'JBM_BidProposals'.
There are 0 rows in 0 pages for object "JBM_BidProposals".
DBCC results for 'IMP_BID_BidColumnAttrib'.
There are 0 rows in 4 pages for object "IMP_BID_BidColumnAttrib".
DBCC results for 'JBM_PHAS'.
There are 585 rows in 20 pages for object "JBM_PHAS".
DBCC results for 'TRC_POAssignVendor_Temp'.
There are 0 rows in 0 pages for object "TRC_POAssignVendor_Temp".
DBCC results for 'FRM_Reflectance'.
There are 10 rows in 2 pages for object "FRM_Reflectance".
DBCC results for 'NEC_Table_5_7_1'.
There are 22 rows in 1 pages for object "NEC_Table_5_7_1".
DBCC results for 'IMP_BID_BNAM'.
There are 0 rows in 1 pages for object "IMP_BID_BNAM".
CHECKDB found 0 allocation errors and 7 consistency errors in database 'CE_DATA'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (CE_DATA).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 20, 2011 at 11:15 am
ronmoses (12/20/2011)
GilaMonster (12/20/2011)
As for how to fix, you posted an incomplete checkDB output, there's at least one, hopefully two more lines to the output. Please post them.Sorry, I was hoping to spare anyone from having to look through all that text. See below.
Didn't actually need all of that. (btw, you can run CheckDB WITH NO_INFOMSGS and all of that useless text will be left out) Just needed this:
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (CE_DATA).
So repair will lose data. Specifically one page of data in the JBM_TPSH table.
What recovery model and what is your backup strategy and frequency?
To fix the JBM_BCMPColumns table, you can drop the nonclustered index that has an ID of 2 and recreate it (don't rebuild it, drop and create)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2011 at 11:19 am
GilaMonster (12/20/2011)
What recovery model and what is your backup strategy and frequency?
Recovery model is full, the backup strategy is something I'll need to talk to the customer about. (This isn't an in-house db, nor am I responsible for backing it up. I work in development.)
To fix the JBM_BCMPColumns table, you can drop the nonclustered index that has an ID of 2 and recreate it (don't rebuild it, drop and create)
Thank you for your help.
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 20, 2011 at 11:27 am
Oh! I almost forgot my original question. So... this would be logical corruption, then? Because the values are screwy? I'm sorry to be such a n00b, it's embarrassing. But I really appreciate your help. You're a credit to the Anla-shok. 😉
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 20, 2011 at 11:30 am
Dunno, what are you defining as 'logical corruption'? It's not a standard term.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2011 at 11:31 am
p.s. For various severities of corruption and fixes, see http://www.sqlservercentral.com/articles/65804/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2011 at 11:33 am
ronmoses (12/20/2011)
GilaMonster (12/20/2011)
What recovery model and what is your backup strategy and frequency?Recovery model is full, the backup strategy is something I'll need to talk to the customer about. (This isn't an in-house db, nor am I responsible for backing it up. I work in development.)
Ok, if there's a clean full backup (one without corruption) and an unbroken chain of log backups we can restore without data loss. Otherwise those rows are gone.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2011 at 11:50 am
GilaMonster (12/20/2011)
Dunno, what are you defining as 'logical corruption'? It's not a standard term.
Sorry, I'd been reading >>this article<< this morning.
Thanks for all the help.
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 20, 2011 at 12:00 pm
Ok, so in Paul's terms this is physical corruption.
Logical corruption would be orphaned rows, data violating assumed constraint, duplicate rows in a table that's supposed to be unique (but doesn't have a unique or pk constraint), incorrect data in a table (age or salary < 0), etc
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply