Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dprworld
Starting Member
4 Posts |
 Posted - 2008-04-18 : 18:03:29
|
| Here's the dbcc of a corrupt database. I had to eventually run it with data loss and piece together the deleted records from an old backup and drop them in a clean db.I apologize in advance if there's an faq out there already that explains my answer in detail...The question I put to you is: 1) How do I we prevent our customers from having this occur again? I can guess the list would include: IO checks, battery backup, SQL 2000 sp4 applied (only sp3 is applied btw), SQL log checks, event log checks. 2) Our custom maint plan includes a dbcc reindex every night and some tables have over 200000 records and a mess of constraints. Is this a potential problem?Thanks.dbcc checkdb -------------DBCC results for 'mycustdb'.DBCC results for 'sysobjects'.There are 3221 rows in 60 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 2694 rows in 223 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 16338 rows in 410 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 2176 rows in 609 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 49 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 13 rows in 1 pages for object 'sysusers'.DBCC results for 'sysproperties'.There are 0 rows in 0 pages for object 'sysproperties'.DBCC results for 'sysdepends'.There are 41985 rows in 214 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 547 rows in 4 pages for object 'sysreferences'.DBCC results for 'sysfulltextcatalogs'.There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.DBCC results for 'sysfulltextnotify'.There are 0 rows in 0 pages for object 'sysfulltextnotify'.DBCC results for 'sysfilegroups'.There are 1 rows in 1 pages for object 'sysfilegroups'.DBCC results for 'sysCompany'.There are 8 rows in 1 pages for object 'sysCompany'.DBCC results for 'a_admResCensus'.There are 0 rows in 0 pages for object 'a_admResCensus'.DBCC results for 'sysTask'.There are 0 rows in 0 pages for object 'sysTask'.DBCC results for 'glJournalEntryTemplate'.There are 7 rows in 1 pages for object 'glJournalEntryTemplate'.DBCC results for 'admResUdAssessAns'.There are 0 rows in 0 pages for object 'admResUdAssessAns'.DBCC results for 'arTAC'.There are 0 rows in 0 pages for object 'arTAC'.DBCC results for 'arRecCharge'.There are 2578 rows in 21 pages for object 'arRecCharge'.DBCC results for 'arFormLocator'.There are 1900 rows in 14 pages for object 'arFormLocator'.DBCC results for 'rptVitalSigns'.There are 0 rows in 0 pages for object 'rptVitalSigns'.DBCC results for 'glMajorDepartment'.There are 0 rows in 0 pages for object 'glMajorDepartment'.DBCC results for 'a_arTAC'.There are 0 rows in 0 pages for object 'a_arTAC'.DBCC results for 'sysUserDefQuesAns'.There are 5128 rows in 41 pages for object 'sysUserDefQuesAns'.DBCC results for 'glTransaction'.There are 67594 rows in 581 pages for object 'glTransaction'.DBCC results for 'arOccupancyRate'.There are 144 rows in 1 pages for object 'arOccupancyRate'.DBCC results for 'sysErrorScreenLink'.There are 60 rows in 1 pages for object 'sysErrorScreenLink'.DBCC results for 'arResCaseMix'.There are 2634 rows in 21 pages for object 'arResCaseMix'.DBCC results for 'glTransImportTemp'.There are 0 rows in 1 pages for object 'glTransImportTemp'.DBCC results for 'arTAR'.There are 0 rows in 0 pages for object 'arTAR'.DBCC results for 'admContactTypeLink'.There are 3460 rows in 15 pages for object 'admContactTypeLink'.DBCC results for 'arResRoomAndBoard'.There are 1839 rows in 16 pages for object 'arResRoomAndBoard'.DBCC results for 'secAccountLink'.There are 0 rows in 0 pages for object 'secAccountLink'.DBCC results for 'glTransToArTransLink'.There are 216168 rows in 478 pages for object 'glTransToArTransLink'.DBCC results for 'arChargeHistory'.There are 634 rows in 4 pages for object 'arChargeHistory'.DBCC results for 'admContPhone'.There are 3091 rows in 17 pages for object 'admContPhone'.DBCC results for 'arRevenueCode'.There are 18 rows in 1 pages for object 'arRevenueCode'.DBCC results for 'glGroup'.There are 1 rows in 1 pages for object 'glGroup'.DBCC results for 'glUnits'.There are 0 rows in 0 pages for object 'glUnits'.DBCC results for 'mdsSectionDefinition'.There are 1735 rows in 71 pages for object 'mdsSectionDefinition'.DBCC results for 'sysUserDefQuesType'.There are 6 rows in 1 pages for object 'sysUserDefQuesType'.DBCC results for 'glUnitType'.There are 0 rows in 0 pages for object 'glUnitType'.DBCC results for 'arChargeUpdTemp'.There are 0 rows in 0 pages for object 'arChargeUpdTemp'.DBCC results for 'arChargeBatch'.There are 2 rows in 1 pages for object 'arChargeBatch'.DBCC results for 'sysWarning'.There are 0 rows in 0 pages for object 'sysWarning'.DBCC results for 'sysCustomReportLayouts'.There are 3 rows in 1 pages for object 'sysCustomReportLayouts'.DBCC results for 'arCheckPoint'.There are 5922 rows in 85 pages for object 'arCheckPoint'.DBCC results for 'arServiceCategory'.There are 47 rows in 1 pages for object 'arServiceCategory'.DBCC results for 'tblClassTemp'.There are 0 rows in 0 pages for object 'tblClassTemp'.DBCC results for 'secCompUserLink'.Server: Msg 8941, Level 16, State 102, Line 1Table error: Object ID 232387897, index ID 0, page (1:35630). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 100, offset 0x1 is invalid.Server: Msg 8942, Level 16, State 1, Line 1Table error: Object ID 232387897, index ID 0, page (1:35630). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x64 overlaps with the prior row.There are 33 rows in 1 pages for object 'secCompUserLink'.DBCC results for 'sysRptMenu'.There are 4 rows in 1 pages for object 'sysRptMenu'.DBCC results for 'a_admResDiagnosis'.There are 0 rows in 0 pages for object 'a_admResDiagnosis'.DBCC results for 'arPaymentHistory'.There are 0 rows in 1 pages for object 'arPaymentHistory'.DBCC results for 'secPermissionLevel'.There are 4 rows in 1 pages for object 'secPermissionLevel'.DBCC results for 'arPaymentLink'.There are 0 rows in 0 pages for object 'arPaymentLink'.DBCC results for 'a_admResident'.There are 0 rows in 0 pages for object 'a_admResident'.DBCC results for 'tblECSLinkTemp'.There are 0 rows in 0 pages for object 'tblECSLinkTemp'.DBCC results for 'mdsVersion'.There are 1 rows in 1 pages for object 'mdsVersion'.DBCC results for 'arResExportDetail'.There are 0 rows in 0 pages for object 'arResExportDetail'.DBCC results for 'tblECSRecordTemp'.There are 0 rows in 0 pages for object 'tblECSRecordTemp'.DBCC results for 'sysRptToMenuLink'.There are 9 rows in 1 pages for object 'sysRptToMenuLink'.DBCC results for 'arResExportHistory'.There are 0 rows in 0 pages for object 'arResExportHistory'.DBCC results for 'arStmtDetailPP'.There are 98372 rows in 887 pages for object 'arStmtDetailPP'.CHECKDB found 0 allocation errors and 2 consistency errors in table 'arStmtDetailPP' (object ID 232387897).DBCC results for 'a_admResInsurance'.There are 0 rows in 0 pages for object 'a_admResInsurance'.DBCC results for 'sysScrnSetting'.There are 331 rows in 8 pages for object 'sysScrnSetting'.DBCC results for 'arStmtChargeLink'.There are 13594 rows in 148 pages for object 'arStmtChargeLink'.DBCC results for 'arStmtDetailUB92'.There are 19070 rows in 221 pages for object 'arStmtDetailUB92'.DBCC results for 'admGender'.There are 3 rows in 1 pages for object 'admGender'.DBCC results for 'arStmtHeaderPP'.There are 15188 rows in 690 pages for object 'arStmtHeaderPP'.DBCC results for 'sysMasterFormLocator'.There are 866 rows in 7 pages for object 'sysMasterFormLocator'.DBCC results for 'rptMdsResCensusTemp'.There are 82 rows in 2 pages for object 'rptMdsResCensusTemp'.DBCC results for 'sysScrnSettingDetail'.There are 3590 rows in 39 pages for object 'sysScrnSettingDetail'.DBCC results for 'arTransHistory'.There are 9767 rows in 57 pages for object 'arTransHistory'.DBCC results for 'arCalculationType'.There are 24 rows in 1 pages for object 'arCalculationType'.DBCC results for 'tblglAcct'.There are 0 rows in 0 pages for object 'tblglAcct'.DBCC results for 'arRate'.There are 1304 rows in 11 pages for object 'arRate'.DBCC results for 'arStmtTransLink'.There are 152635 rows in 324 pages for object 'arStmtTransLink'.DBCC results for 'a_admResNotes'.There are 0 rows in 0 pages for object 'a_admResNotes'.DBCC results for 'admMaritalStatus'.There are 6 rows in 1 pages for object 'admMaritalStatus'.DBCC results for 'tblglBgtAcct'.There are 0 rows in 0 pages for object 'tblglBgtAcct'.DBCC results for 'sysSpellDict'.There are 15438 rows in 94 pages for object 'sysSpellDict'.DBCC results for 'arSpecRate'.There are 40 rows in 1 pages for object 'arSpecRate'.DBCC results for 'arTFIntsTemp'.There are 0 rows in 0 pages for object 'arTFIntsTemp'.DBCC results for 'sysInsuranceType'.There are 81 rows in 1 pages for object 'sysInsuranceType'.DBCC results for 'tblglDept'.There are 0 rows in 0 pages for object 'tblglDept'.DBCC results for 'tblSpellDict'.There are 15357 rows in 91 pages for object 'tblSpellDict'.DBCC results for 'arToGLTemp'.There are 0 rows in 1 pages for object 'arToGLTemp'.DBCC results for 'sysUdQuest'.There are 0 rows in 0 pages for object 'sysUdQuest'.DBCC results for 'tblglFNPeriod'.There are 0 rows in 0 pages for object 'tblglFNPeriod'.DBCC results for 'admResRoom'.There are 1820 rows in 11 pages for object 'admResRoom'.DBCC results for 'admResDiagnosis'.There are 6480 rows in 63 pages for object 'admResDiagnosis'.DBCC results for 'tblglTrans'.There are 0 rows in 0 pages for object 'tblglTrans'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'arStatement'.There are 17784 rows in 102 pages for object 'arStatement'.DBCC results for 'sysMasterFormVersion'.There are 51 rows in 1 pages for object 'sysMasterFormVersion'.DBCC results for 'admComments'.There are 0 rows in 0 pages for object 'admComments'.DBCC results for 'tblglUnit'.There are 0 rows in 0 pages for object 'tblglUnit'.DBCC results for 'arPercentage'.There are 2 rows in 1 pages for object 'arPercentage'.DBCC results for 'arTransLink'.There are 103583 rows in 372 pages for object 'arTransLink'.DBCC results for 'a_admResRoom'.There are 0 rows in 0 pages for object 'a_admResRoom'.DBCC results for 'mdsAssessment'.There are 9 rows in 2 pages for object 'mdsAssessment'.DBCC results for 'arTransLinkTemp'.There are 0 rows in 1 pages for object 'arTransLinkTemp'.DBCC results for 'mdsAssessSummary'.There are 3933 rows in 87 pages for object 'mdsAssessSummary'.DBCC results for 'sysReportCategories'.There are 53 rows in 1 pages for object 'sysReportCategories'.DBCC results for 'a_admResSchdCodePassTime'.There are 0 rows in 0 pages for object 'a_admResSchdCodePassTime'.DBCC results for 'admPhyOrderPassTime'.There are 51 rows in 1 pages for object 'admPhyOrderPassTime'.DBCC results for 'admTaskData'.There are 0 rows in 0 pages for object 'admTaskData'.DBCC results for 'arTransOrigin'.There are 12 rows in 1 pages for object 'arTransOrigin'.DBCC results for 'ap1099Form'.There are 89 rows in 5 pages for object 'ap1099Form'.DBCC results for 'sysDiagnosis'.There are 16464 rows in 165 pages for object 'sysDiagnosis'.DBCC results for 'mdsRugsFormLocators'.There are 9 rows in 1 pages for object 'mdsRugsFormLocators'.DBCC results for 'admPhyOrdersHistory'.There are 20165 rows in 300 pages for object 'admPhyOrdersHistory'.DBCC results for 'rptTempTable'.There are 4 rows in 1 pages for object 'rptTempTable'.DBCC results for 'tblRandomNames'.There are 0 rows in 0 pages for object 'tblRandomNames'.DBCC results for 'mdsRugsMedicaid'.There are 518 rows in 4 pages for object 'mdsRugsMedicaid'.DBCC results for 'arTransType'.There are 10 rows in 1 pages for object 'arTransType'.DBCC results for 'mdsRugsMedicare'.There are 582 rows in 5 pages for object 'mdsRugsMedicare'.DBCC results for 'arECSError'.There are 13 rows in 1 pages for object 'arECSError'.DBCC results for 'apBatch'.There are 1771 rows in 15 pages for object 'apBatch'.DBCC results for 'arOrderTypeServiceLink'.There are 0 rows in 0 pages for object 'arOrderTypeServiceLink'.DBCC results for 'a_arBatch'.There are 0 rows in 0 pages for object 'a_arBatch'.DBCC results for 'arECSPayment'.There are 0 rows in 0 pages for object 'arECSPayment'.DBCC results for 'arTreatment'.There are 0 rows in 0 pages for object 'arTreatment'.DBCC results for 'apCheck'.There are 8822 rows in 83 pages for object 'apCheck'.DBCC results for 'arECSPmtAdjustment'.There are 0 rows in 0 pages for object 'arECSPmtAdjustment'.DBCC results for 'arStmtDetailCMS1500'.There are 0 rows in 0 pages for object 'arStmtDetailCMS1500'.DBCC results for 'admProfLink2'.There are 1890 rows in 8 pages for object 'admProfLink2'.DBCC results for 'a_arTreatment'.There are 0 rows in 0 pages for object 'a_arTreatment'.DBCC results for 'apCheckHistory'.There are 8800 rows in 44 pages for object 'apCheckHistory'.DBCC results for 'arStmtHeaderCMS1500'.There are 0 rows in 0 pages for object 'arStmtHeaderCMS1500'.DBCC results for 'sysCoPhone'.There are 13 rows in 1 pages for object 'sysCoPhone'.DBCC results for 'repUserRptCatLink'.There are 63 rows in 1 pages for object 'repUserRptCatLink'.DBCC results for 'dc_ecshst_d'.There are 0 rows in 0 pages for object 'dc_ecshst_d'.DBCC results for 'apCheckNumTemp'.There are 0 rows in 1 pages for object 'apCheckNumTemp'.DBCC results for 'sysECSAdjReasonCode'.There are 40 rows in 1 pages for object 'sysECSAdjReasonCode'.DBCC results for 'hl7ExceptionLog'.There are 0 rows in 0 pages for object 'hl7ExceptionLog'.DBCC results for 'apCheckPoint'.There are 2848 rows in 40 pages for object 'apCheckPoint'.DBCC results for 'rptErrorWarning'.There are 66 rows in 5 pages for object 'rptErrorWarning'.DBCC results for 'hl7MsgQueueIncoming'.There are 0 rows in 0 pages for object 'hl7MsgQueueIncoming'.DBCC results for 'admProfPhone'.There are 155 rows in 1 pages for object 'admProfPhone'.DBCC results for 'hl7ProcessingErrors'.There are 0 rows in 0 pages for object 'hl7ProcessingErrors'.DBCC results for 'arTFBatchDetail'.There are 2 rows in 1 pages for object 'arTFBatchDetail'.DBCC results for 'rptFacilityRUGReport'.There are 0 rows in 0 pages for object 'rptFacilityRUGReport'.DBCC results for 'hl7RawMsgIncoming'.There are 0 rows in 0 pages for object 'hl7RawMsgIncoming'.DBCC results for 'apInvoice'.There are 12516 rows in 167 pages for object 'apInvoice'.DBCC results for 'tblDiagSubject'.There are 1217 rows in 7 pages for object 'tblDiagSubject'.DBCC results for 'dc_ub92_d'.There are 0 rows in 0 pages for object 'dc_ub92_d'.DBCC results for 'mdsAssessSignature'.There are 4322 rows in 59 pages for object 'mdsAssessSignature'.DBCC results for 'a_arChargeTransLink'.There are 0 rows in 0 pages for object 'a_arChargeTransLink'.DBCC results for 'mdsCMLink'.There are 105 rows in 2 pages for object 'mdsCMLink'.DBCC results for 'dosConvertCriteria'.There are 0 rows in 0 pages for object 'dosConvertCriteria'.DBCC results for 'admRace'.There are 6 rows in 1 pages for object 'admRace'.DBCC results for 'rptMDSAssmtDue'.There are 0 rows in 1 pages for object 'rptMDSAssmtDue'.DBCC results for 'a_mdsAssessSignature'.There are 0 rows in 0 pages for object 'a_mdsAssessSignature'.DBCC results for 'a_arNote'.There are 0 rows in 0 pages for object 'a_arNote'.DBCC results for 'apInvoiceBatch'.There are 966 rows in 5 pages for object 'apInvoiceBatch'.DBCC results for 'dosConvertFields'.There are 392 rows in 3 pages for object 'dosConvertFields'.DBCC results for 'rptMDSAssmtDueByDate'.There are 0 rows in 1 pages for object 'rptMDSAssmtDueByDate'.DBCC results for 'mdsAssessSignTypes'.There are 9 rows in 1 pages for object 'mdsAssessSignTypes'.DBCC results for 'a_arPAWorksheetDetail'.There are 0 rows in 0 pages for object 'a_arPAWorksheetDetail'.DBCC results for 'apInvoiceBatchDetail'.There are 47 rows in 1 pages for object 'apInvoiceBatchDetail'.DBCC results for 'rptMDSCurrentECSItems'.There are 0 rows in 0 pages for object 'rptMDSCurrentECSItems'.DBCC results for 'a_arPayment'.There are 0 rows in 0 pages for object 'a_arPayment'.DBCC results for 'apInvoiceBatchTransDetail'.There are 50 rows in 1 pages for object 'apInvoiceBatchTransDetail'.DBCC results for 'mdsCMMaximizer'.There are 15 rows in 1 pages for object 'mdsCMMaximizer'.DBCC results for 'apInvoiceCheckLink'.There are 12497 rows in 59 pages for object 'apInvoiceCheckLink'.DBCC results for 'mdsRugsUserRateMC'.There are 27 rows in 1 pages for object 'mdsRugsUserRateMC'.DBCC results for 'dosConvertFiles'.There are 1 rows in 1 pages for object 'dosConvertFiles'.DBCC results for 'sysAllergyCodes'.There are 249 rows in 2 pages for object 'sysAllergyCodes'.DBCC results for 'sysECSFileCount'.There are 0 rows in 0 pages for object 'sysECSFileCount'.DBCC results for 'mdsStartDates'.There are 0 rows in 0 pages for object 'mdsStartDates'.DBCC results for 'a_arRecCharge'.There are 0 rows in 0 pages for object 'a_arRecCharge'.DBCC results for 'apInvoiceHistory'.There are 12681 rows in 138 pages for object 'apInvoiceHistory'.DBCC results for 'rptCurrentPrevalence'.There are 0 rows in 0 pages for object 'rptCurrentPrevalence'.DBCC results for 'admResAllergy'.There are 762 rows in 7 pages for object 'admResAllergy'.DBCC results for 'apMiscAdjMemo'.There are 0 rows in 0 pages for object 'apMiscAdjMemo'.DBCC results for 'sysFeatCompanyLink'.There are 82 rows in 1 pages for object 'sysFeatCompanyLink'.DBCC results for 'a_arResCaseMix'.There are 0 rows in 0 pages for object 'a_arResCaseMix'.DBCC results for 'apNote'.There are 1 rows in 1 pages for object 'apNote'.DBCC results for 'rptDiseaseProfile'.There are 0 rows in 0 pages for object 'rptDiseaseProfile'.DBCC results for 'a_arResRoomAndBoard'.There are 0 rows in 0 pages for object 'a_arResRoomAndBoard'.DBCC results for 'rptDiseaseProfileDetail'.There are 0 rows in 0 pages for object 'rptDiseaseProfileDetail'.DBCC results for 'a_arStatement'.There are 0 rows in 0 pages for object 'a_arStatement'.DBCC results for 'apPaymentBatch'.There are 793 rows in 3 pages for object 'apPaymentBatch'.DBCC results for 'arStmtAdjmtUB92'.There are 0 rows in 0 pages for object 'arStmtAdjmtUB92'.DBCC results for 'apPaymentTerms'.There are 6 rows in 1 pages for object 'apPaymentTerms'.DBCC results for 'rptFacLongProfile'.There are 0 rows in 0 pages for object 'rptFacLongProfile'.DBCC results for 'mdsAnswerNotes'.There are 6270 rows in 91 pages for object 'mdsAnswerNotes'.DBCC results for 'a_arStmtDetailCMS1500'.There are 0 rows in 0 pages for object 'a_arStmtDetailCMS1500'.DBCC results for 'mdsAnswerReasons'.There are 28 rows in 1 pages for object 'mdsAnswerReasons'.DBCC results for 'a_arStmtDetailPP'.There are 0 rows in 0 pages for object 'a_arStmtDetailPP'.DBCC results for 'apPmtBatchDetail'.There are 0 rows in 1 pages for object 'apPmtBatchDetail'.DBCC results for 'rptHistoricalPrevalence'.There are 0 rows in 0 pages for object 'rptHistoricalPrevalence'.DBCC results for 'a_arStmtDetailUB92'.There are 0 rows in 0 pages for object 'a_arStmtDetailUB92'.DBCC results for 'apRecInvDetail'.There are 15 rows in 1 pages for object 'apRecInvDetail'.DBCC results for 'admContact'.There are 2346 rows in 18 pages for object 'admContact'.DBCC results for 'mdsAssessSectionLink'.There are 222 rows in 1 pages for object 'mdsAssessSectionLink'.DBCC results for 'admCounty'.There are 1301 rows in 5 pages for object 'admCounty'.DBCC results for 'sysGridFilter'.There are 88 rows in 1 pages for object 'sysGridFilter'.DBCC results for 'a_arStmtHeaderCMS1500'.There are 0 rows in 0 pages for object 'a_arStmtHeaderCMS1500'.DBCC results for 'apRecInvTemp'.There are 0 rows in 1 pages for object 'apRecInvTemp'.DBCC results for 'admContactRelation'.There are 28 rows in 1 pages for object 'admContactRelation'.DBCC results for 'rptLongResProfileDetail'.There are 0 rows in 0 pages for object 'rptLongResProfileDetail'.DBCC results for 'a_arStmtHeaderPP'.There are 0 rows in 0 pages for object 'a_arStmtHeaderPP'.DBCC results for 'apRecurringInvoice'.There are 14 rows in 1 pages for object 'apRecurringInvoice'.DBCC results for 'admResident'.There are 1018 rows in 16 pages for object 'admResident'.DBCC results for 'rptLongResProfileHeader'.There are 0 rows in 0 pages for object 'rptLongResProfileHeader'.DBCC results for 'sysListMenu'.There are 24 rows in 1 pages for object 'sysListMenu'.DBCC results for 'a_arStmtHeaderUB92'.There are 0 rows in 0 pages for object 'a_arStmtHeaderUB92'.DBCC results for 'sysFeature'.There are 34 rows in 1 pages for object 'sysFeature'.DBCC results for 'sysCountyIndex'.There are 10331 rows in 76 pages for object 'sysCountyIndex'.DBCC results for 'sysListSettings'.There are 144 rows in 2 pages for object 'sysListSettings'.DBCC results for 'a_arTransaction'.There are 0 rows in 0 pages for object 'a_arTransaction'.DBCC results for 'apStartPaidBalance'.There are 0 rows in 0 pages for object 'apStartPaidBalance'.DBCC results for 'admResNotes'.There are 248 rows in 3 pages for object 'admResNotes'.DBCC results for 'secDefaultGroups'.There are 476 rows in 4 pages for object 'secDefaultGroups'.DBCC results for 'apStatement'.There are 0 rows in 0 pages for object 'apStatement'.DBCC results for 'arService'.There are 312 rows in 4 pages for object 'arService'.DBCC results for 'secUserAlertLink'.There are 3 rows in 1 pages for object 'secUserAlertLink'.DBCC results for 'sysLaborPercentage'.There are 10 rows in 1 pages for object 'sysLaborPercentage'.DBCC results for 'audAccess'.There are 145672 rows in 1092 pages for object 'audAccess'.DBCC results for 'sysGovRelationship'.There are 20 rows in 1 pages for object 'sysGovRelationship'.DBCC results for 'sysAlert'.There are 3 rows in 1 pages for object 'sysAlert'.DBCC results for 'sysMasterForm'.There are 6 rows in 1 pages for object 'sysMasterForm'.DBCC results for 'audAction'.There are 0 rows in 0 pages for object 'audAction'.DBCC results for 'apStmtTransLink'.There are 0 rows in 0 pages for object 'apStmtTransLink'.DBCC results for 'arStmtHeaderUB92'.There are 2234 rows in 315 pages for object 'arStmtHeaderUB92'.DBCC results for 'mdsDiagnosisCPLink'.There are 0 rows in 0 pages for object 'mdsDiagnosisCPLink'.DBCC results for 'audEvent'.There are 301723 rows in 1240 pages for object 'audEvent'.DBCC results for 'apTransaction'.There are 21579 rows in 181 pages for object 'apTransaction'.DBCC results for 'sysImportLog'.There are 998 rows in 8 pages for object 'sysImportLog'.DBCC results for 'mdsECSBatchInfo'.There are 585 rows in 7 pages for object 'mdsECSBatchInfo'.DBCC results for 'audEventType'.There are 17 rows in 1 pages for object 'audEventType'.DBCC results for 'sysMasterCP'.There are 23 rows in 1 pages for object 'sysMasterCP'.DBCC results for 'sysCaseMixVersion'.There are 9 rows in 1 pages for object 'sysCaseMixVersion'.DBCC results for 'mdsLock'.There are 0 rows in 1 pages for object 'mdsLock'.DBCC results for 'audLogin'.There are 5399 rows in 42 pages for object 'audLogin'.DBCC results for 'apTransDetail'.There are 45417 rows in 254 pages for object 'apTransDetail'.DBCC results for 'sysCaseMixVersionLink'.There are 343 rows in 1 pages for object 'sysCaseMixVersionLink'.DBCC results for 'mdsMDSCPLink'.There are 12 rows in 1 pages for object 'mdsMDSCPLink'.DBCC results for 'audTableActionLink'.There are 0 rows in 0 pages for object 'audTableActionLink'.DBCC results for 'apTransDetailTemp'.There are 0 rows in 1 pages for object 'apTransDetailTemp'.DBCC results for 'sysMedAllergyLink'.There are 0 rows in 0 pages for object 'sysMedAllergyLink'.DBCC results for 'sysUdAssess'.There are 0 rows in 0 pages for object 'sysUdAssess'.DBCC results for 'mdsMedCPLink'.There are 0 rows in 0 pages for object 'mdsMedCPLink'.DBCC results for 'sysControlSubstance'.There are 7 rows in 1 pages for object 'sysControlSubstance'.DBCC results for 'a_ecsRecords'.There are 0 rows in 0 pages for object 'a_ecsRecords'.DBCC results for 'apTransDetailType'.There are 9 rows in 1 pages for object 'apTransDetailType'.DBCC results for 'sysMedia'.There are 570 rows in 3 pages for object 'sysMedia'.DBCC results for 'mdsRAPs'.There are 18 rows in 1 pages for object 'mdsRAPs'.DBCC results for 'sysProcess'.There are 31953 rows in 147 pages for object 'sysProcess'.DBCC results for 'apTransHistory'.There are 20944 rows in 49 pages for object 'apTransHistory'.DBCC results for 'sysResSumByProbRptList'.There are 39 rows in 2 pages for object 'sysResSumByProbRptList'.DBCC results for 'arUserDefRate'.There are 32 rows in 1 pages for object 'arUserDefRate'.DBCC results for 'mdsRAPTriggerCPLink'.There are 0 rows in 0 pages for object 'mdsRAPTriggerCPLink'.DBCC results for 'sysDiagSubject'.There are 1240 rows in 7 pages for object 'sysDiagSubject'.DBCC results for 'admDischargeCode'.There are 17 rows in 1 pages for object 'admDischargeCode'.DBCC results for 'apTransOrigin'.There are 4 rows in 1 pages for object 'apTransOrigin'.DBCC results for 'a_admCarePlan'.There are 0 rows in 0 pages for object 'a_admCarePlan'.DBCC results for 'sysUdQuestAns'.There are 0 rows in 0 pages for object 'sysUdQuestAns'.DBCC results for 'sysECSEntityQualifier'.There are 25 rows in 1 pages for object 'sysECSEntityQualifier'.DBCC results for 'admMilitaryBranch'.There are 6 rows in 1 pages for object 'admMilitaryBranch'.DBCC results for 'a_mdsAnswerNotes'.There are 0 rows in 0 pages for object 'a_mdsAnswerNotes'.DBCC results for 'apTransType'.There are 4 rows in 1 pages for object 'apTransType'.DBCC results for 'sysUdQuestType'.There are 10 rows in 1 pages for object 'sysUdQuestType'.DBCC results for 'mdsRAPVersionLink'.There are 18 rows in 1 pages for object 'mdsRAPVersionLink'.DBCC results for 'sysECSFileFormat'.There are 3 rows in 1 pages for object 'sysECSFileFormat'.DBCC results for 'a_mdsAnswerReasons'.There are 0 rows in 0 pages for object 'a_mdsAnswerReasons'.DBCC results for 'apVendor'.There are 1776 rows in 13 pages for object 'apVendor'.DBCC results for 'tblResSumByProbRptList'.There are 37 rows in 1 pages for object 'tblResSumByProbRptList'.DBCC results for 'sysECSFileFormatVer'.There are 21 rows in 1 pages for object 'sysECSFileFormatVer'.DBCC results for 'admReligion'.There are 49 rows in 1 pages for object 'admReligion'.DBCC results for 'sysReportCatFields'.There are 1311 rows in 17 pages for object 'sysReportCatFields'.DBCC results for 'a_mdsAssessSummary'.There are 0 rows in 0 pages for object 'a_mdsAssessSummary'.DBCC results for 'a_arCharge'.There are 0 rows in 0 pages for object 'a_arCharge'.DBCC results for 'sysMedWarningLink'.There are 0 rows in 0 pages for object 'sysMedWarningLink'.DBCC results for 'sysECSFormVerToFileFormatVerLink'.There are 50 rows in 1 pages for object 'sysECSFormVerToFileFormatVerLink'.DBCC results for 'sysECSSrcPmtCodeMap'.There are 11 rows in 1 pages for object 'sysECSSrcPmtCodeMap'.DBCC results for 'admState'.There are 53 rows in 1 pages for object 'admState'.DBCC results for 'arAccount'.There are 1555 rows in 16 pages for object 'arAccount'.DBCC results for 'sysFDACode'.There are 7 rows in 1 pages for object 'sysFDACode'.DBCC results for 'sysReportCatFK'.There are 70 rows in 1 pages for object 'sysReportCatFK'.DBCC results for 'apVendorContact'.There are 13 rows in 1 pages for object 'apVendorContact'.DBCC results for 'sysOrderType'.There are 22 rows in 1 pages for object 'sysOrderType'.DBCC results for 'a_secAccessControl'.There are 0 rows in 0 pages for object 'a_secAccessControl'.DBCC results for 'mdsReactionActions'.There are 838 rows in 4 pages for object 'mdsReactionActions'.DBCC results for 'arAccountType'.There are 22 rows in 1 pages for object 'arAccountType'.DBCC results for 'sysFreqCodes'.There are 24 rows in 1 pages for object 'sysFreqCodes'.DBCC results for 'a_secAccountLink'.There are 0 rows in 0 pages for object 'a_secAccountLink'.DBCC results for 'apVendorPhone'.There are 567 rows in 3 pages for object 'apVendorPhone'.DBCC results for 'rptCarePlan'.There are 0 rows in 0 pages for object 'rptCarePlan'.DBCC results for 'secAccountPwdHistory'.There are 0 rows in 0 pages for object 'secAccountPwdHistory'.DBCC results for 'apVoidReason'.There are 23 rows in 1 pages for object 'apVoidReason'.DBCC results for 'a_secAccounts'.There are 0 rows in 0 pages for object 'a_secAccounts'.DBCC results for 'a_arStmtHeaderUB04'.There are 0 rows in 0 pages for object 'a_arStmtHeaderUB04'.DBCC results for 'sysResSumByProbRptECSKeys'.There are 172 rows in 1 pages for object 'sysResSumByProbRptECSKeys'.DBCC results for 'arStmtDetailUCF'.There are 0 rows in 0 pages for object 'arStmtDetailUCF'.DBCC results for 'arStmtHeaderUB04'.There are 362 rows in 67 pages for object 'arStmtHeaderUB04'.DBCC results for 'mdsReactionCauses'.There are 932 rows in 4 pages for object 'mdsReactionCauses'.DBCC results for 'rptKeyLookup'.There are 85 rows in 2 pages for object 'rptKeyLookup'.DBCC results for 'sysGridColumn'.There are 768 rows in 10 pages for object 'sysGridColumn'.DBCC results for 'admResSchdCodePassTime'.There are 0 rows in 0 pages for object 'admResSchdCodePassTime'.DBCC results for 'sysSQL'.There are 17 rows in 7 pages for object 'sysSQL'.DBCC results for 'a_arStmtDetailUCF'.There are 0 rows in 0 pages for object 'a_arStmtDetailUCF'.DBCC results for 'rptFlowsheetResidents'.There are 0 rows in 0 pages for object 'rptFlowsheetResidents'.DBCC results for 'sysPGA'.There are 1166 rows in 19 pages for object 'sysPGA'.DBCC results for 'arStmtHeaderUCF'.There are 0 rows in 0 pages for object 'arStmtHeaderUCF'.DBCC results for 'rptMDSResRoster'.There are 84 rows in 3 pages for object 'rptMDSResRoster'.DBCC results for 'a_arStmtHeaderUCF'.There are 0 rows in 0 pages for object 'a_arStmtHeaderUCF'.DBCC results for 'rptNAAFormResidents'.There are 0 rows in 0 pages for object 'rptNAAFormResidents'.DBCC results for 'sysPGAMCPLink'.There are 191 rows in 1 pages for object 'sysPGAMCPLink'.DBCC results for 'sysUserScreenSettings'.There are 25 rows in 1 pages for object 'sysUserScreenSettings'.DBCC results for 'glAcctAttribute'.There are 19 rows in 1 pages for object 'glAcctAttribute'.DBCC results for 'rptResidentinfo'.There are 2 rows in 1 pages for object 'rptResidentinfo'.DBCC results for 'glAcctToDistCodeLink'.There are 0 rows in 0 pages for object 'glAcctToDistCodeLink'.DBCC results for 'admNATasks'.There are 0 rows in 0 pages for object 'admNATasks'.DBCC results for 'glAttribute'.There are 4 rows in 1 pages for object 'glAttribute'.DBCC results for 'admCarePlan'.There are 671 rows in 14 pages for object 'admCarePlan'.DBCC results for 'secAccessControl'.There are 9474 rows in 44 pages for object 'secAccessControl'.DBCC results for 'admPhyOrders'.Server: Msg 2534, Level 16, State 1, Line 1Table error: Page (1:27978) with object ID 1395757021, index ID 0 in its header is allocated by another object.Server: Msg 2534, Level 16, State 1, Line 1Table error: Page (1:27979) with object ID 1395757021, index ID 0 in its header is allocated by another object.Server: Msg 2534, Level 16, State 1, Line 1Table error: Page (1:27980) with object ID 1395757021, index ID 0 in its header is allocated by another object.Server: Msg 2534, Level 16, State 1, Line 1Table error: Page (1:27981) with object ID 1395757021, index ID 0 in its header is allocated by another object.Server: Msg 2534, Level 16, State 1, Line 1Table error: Page (1:27982) with object ID 1395757021, index ID 0 in its header is allocated by another object.Server: Msg 2534, Level 16, State 1, Line 1Table error: Page (1:27983) with object ID 1395757021, index ID 0 in its header is allocated by another object.Server: Msg 2534, Level 16, State 1, Line 1Table error: Page (1:27984) with object ID 1395757021, index ID 0 in its header is allocated by another object.Server: Msg 8944, Level 16, State 1, Line 1Table error: Object ID 1395757021, index ID 0, page (1:27985), row 1. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 94 and 193.Server: Msg 8944, Level 16, State 1, Line 1Table error: Object ID 1395757021, index ID 0, page (1:27985), row 1. Test (GetRecType (pRec) >= 0 && GetRecType (pRec) <= LAST_REC_TYPE) failed. Values are 14 and 12.Server: Msg 8926, Level 16, State 1, Line 1Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1395757021, index ID 1, and page (1:27977), slot 0, in object ID 1539757534, index ID 1, next refer to page (1:27978) but are not in the same object.Server: Msg 8926, Level 16, State 1, Line 1Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1395757021, index ID 1, and page (1:28007), slot 0, in object ID 1539757534, index ID 1, next refer to page (1:27984) but are not in the same object.Server: Msg 8936, Level 16, State 1, Line 1Table error: Object ID 1395757021, index ID 1. B-tree chain linkage mismatch. (1:28007)->next = (1:27984), but (1:27984)->Prev = (1:27983).Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539080819, index ID 20. B-tree page (1:14640) has two parent nodes (0:1), slot 0 and (0:0), slot 0.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:27978) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:27979) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:27980) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:27981) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:27982) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:27983) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:27984) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1539757534, index ID 0: Page (1:27985) could not be processed. See other errors for details.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35629) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1539757534, index ID 0: Page (1:35630) could not be processed. See other errors for details.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35638) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35639) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35640) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35641) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35642) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35643) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35644) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1539757534, index ID 0: Page (1:35785) could not be processed. See other errors for details.Server: Msg 8944, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 0, page (1:35785), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 133 and 57.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35786) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35787) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:35788) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Page (1:27968) is missing a reference from previous page (1:27983). Possible chain linkage problem.Server: Msg 8982, Level 16, State 1, Line 1Table error: Cross object linkage. Page (1:27977)->next in object ID 1539757534, index ID 1 refers to page (1:27978) in object ID 1395757021, index ID 1 but is not in the same index.Server: Msg 8925, Level 16, State 1, Line 1Table error: Cross object linkage: Page (1:28984), slot 88, in object ID 1539757534, index ID 1, refers to page (1:27984), slot 0, in object ID 1395757021, index ID 1.Server: Msg 8926, Level 16, State 1, Line 1Table error: Cross object linkage: Parent page (1:28984), slot 89, in object ID 1539757534, index ID 1, and page (1:27984), slot 0, in object ID 1395757021, index ID 1, next refer to page (1:27985) but are not in the same object.Server: Msg 8925, Level 16, State 1, Line 1Table error: Cross object linkage: Page (1:28984), slot 98, in object ID 1539757534, index ID 1, refers to page (1:27978), slot 0, in object ID 1395757021, index ID 1.Server: Msg 8925, Level 16, State 1, Line 1Table error: Cross object linkage: Page (1:28984), slot 99, in object ID 1539757534, index ID 1, refers to page (1:27979), slot 0, in object ID 1395757021, index ID 1.There are 4539 rows in 75 pages for object 'admPhyOrders'.DBCC results for 'a_secCompUserLink'.There are 0 rows in 0 pages for object 'a_secCompUserLink'.DBCC results for 'glDueToDueFrom'.There are 0 rows in 0 pages for object 'glDueToDueFrom'.DBCC results for 'sysInfo'.There are 1 rows in 1 pages for object 'sysInfo'.DBCC results for 'arPayment'.There are 24361 rows in 360 pages for object 'arPayment'.CHECKDB found 0 allocation errors and 12 consistency errors in table 'arPayment' (object ID 1395757021).DBCC results for 'glTransToAPTransLink'.There are 44021 rows in 101 pages for object 'glTransToAPTransLink'.DBCC results for 'secGenSettings'.There are 1 rows in 1 pages for object 'secGenSettings'.DBCC results for 'mdsQuestions'.There are 1716 rows in 19 pages for object 'mdsQuestions'.DBCC results for 'arBillingCategory'.There are 13 rows in 1 pages for object 'arBillingCategory'.DBCC results for 'sysTaskCodes'.There are 0 rows in 0 pages for object 'sysTaskCodes'.DBCC results for 'arBatch'.There are 4147 rows in 45 pages for object 'arBatch'.DBCC results for 'arBillingForm'.There are 16 rows in 1 pages for object 'arBillingForm'.DBCC results for 'arPaymentBatchDetail'.There are 2 rows in 1 pages for object 'arPaymentBatchDetail'.DBCC results for 'sysWizardPage'.There are 67 rows in 1 pages for object 'sysWizardPage'.DBCC results for 'tblapVendor'.There are 0 rows in 0 pages for object 'tblapVendor'.DBCC results for 'a_admPhyOrderAdmin'.There are 0 rows in 0 pages for object 'a_admPhyOrderAdmin'.DBCC results for 'arBillingParty'.There are 64 rows in 1 pages for object 'arBillingParty'.DBCC results for 'sysWizardSettings'.There are 22 rows in 1 pages for object 'sysWizardSettings'.DBCC results for 'a_secGenSettings'.There are 0 rows in 0 pages for object 'a_secGenSettings'.DBCC results for 'sysInsuranceProvider'.There are 78 rows in 1 pages for object 'sysInsuranceProvider'.DBCC results for 'a_admResPGA'.There are 0 rows in 0 pages for object 'a_admResPGA'.DBCC results for 'arCharge'.There are 80123 rows in 1521 pages for object 'arCharge'.DBCC results for 'admResCensus'.There are 303 rows in 2 pages for object 'admResCensus'.DBCC results for 'rptAssessmentScreening'.There are 0 rows in 0 pages for object 'rptAssessmentScreening'.DBCC results for 'arBPartyInsTypeLink'.There are 26 rows in 1 pages for object 'arBPartyInsTypeLink'.DBCC results for 'sysMedicationFile'.There are 168 rows in 3 pages for object 'sysMedicationFile'.CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysMedicationFile' (object ID 1539080819).DBCC results for 'arTransaction'.Server: Msg 8925, Level 16, State 1, Line 1Table error: Cross object linkage: Page (1:28984), slot 100, in object ID 1539757534, index ID 1, refers to page (1:27980), slot 0, in object ID 1395757021, index ID 1.Server: Msg 8925, Level 16, State 1, Line 1Table error: Cross object linkage: Page (1:28984), slot 101, in object ID 1539757534, index ID 1, refers to page (1:27981), slot 0, in object ID 1395757021, index ID 1.Server: Msg 8925, Level 16, State 1, Line 1Table error: Cross object linkage: Page (1:28984), slot 102, in object ID 1539757534, index ID 1, refers to page (1:27982), slot 0, in object ID 1395757021, index ID 1.Server: Msg 8925, Level 16, State 1, Line 1Table error: Cross object linkage: Page (1:28984), slot 103, in object ID 1539757534, index ID 1, refers to page (1:27983), slot 0, in object ID 1395757021, index ID 1.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Page (1:35624) is missing a reference from previous page (1:35639). Possible chain linkage problem.Server: Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Page (1:35629) was not seen in the scan although its parent (1:36209) and previous (1:35628) refer to it. Check any previous errors.Server: Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Page (1:35638) was not seen in the scan although its parent (1:36209) and previous (1:35637) refer to it. Check any previous errors.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 262 refers to child page (1:35639) and previous child (1:35638), but they were not encountered.Server: Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Page (1:35640) was not seen in the scan although its parent (1:36209) and previous (1:35655) refer to it. Check any previous errors.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 248 refers to child page (1:35641) and previous child (1:35640), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 249 refers to child page (1:35642) and previous child (1:35641), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 250 refers to child page (1:35643) and previous child (1:35642), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 251 refers to child page (1:35644) and previous child (1:35643), but they were not encountered.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Page (1:35645) is missing a reference from previous page (1:35644). Possible chain linkage problem.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 202 refers to child page (1:35787) and previous child (1:35786), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 203 refers to child page (1:35788) and previous child (1:35787), but they were not encountered.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 1. Page (1:35789) is missing a reference from previous page (1:35788). Possible chain linkage problem.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24303) (level 0) is not less than the low key value in the parent (1:24802), slot 160 of the next page (1:24288).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24304) (level 0) is not less than the low key value in the parent (1:24802), slot 145 of the next page (1:24305).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24305) (level 0) is not less than the low key value in the parent (1:24802), slot 146 of the next page (1:24306).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24306) (level 0) is not less than the low key value in the parent (1:24802), slot 147 of the next page (1:24307).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24307) (level 0) is not less than the low key value in the parent (1:24802), slot 148 of the next page (1:24308).Server: Msg 8934, Level 16, State 2, Line 1Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24308) (level 0) is not less than the low key value in the parent (1:24802), slot 149 of the next page (1:24309).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24309) (level 0) is not less than the low key value in the parent (1:24802), slot 150 of the next page (1:24310).Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 20. Keys out of order on page (1:24310), slots 332 and 333.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 20. Keys out of order on page (1:24310), slots 333 and 334.Server: Msg 8981, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The next pointer of (1:22815) refers to page (1:22760). Neither (1:22760) nor its parent were encountered. Possible bad chain linkage.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. Page (1:22800) is missing a reference from previous page (1:22815). Possible chain linkage problem.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The high key value on page (1:22810) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:22811).Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22811) (level 0) is not >= the key value in the parent (1:23522) slot 321.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22812) (level 0) is not >= the key value in the parent (1:23522) slot 322.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22813) (level 0) is not >= the key value in the parent (1:23522) slot 323.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22814) (level 0) is not >= the key value in the parent (1:23522) slot 324.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22815) (level 0) is not >= the key value in the parent (1:23522) slot 325.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22816) (level 0) is not >= the key value in the parent (1:23522) slot 310.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22817) (level 0) is not >= the key value in the parent (1:23522) slot 311.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 21. Keys out of order on page (1:22825), slots 333 and 334.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 21. Keys out of order on page (1:22825), slots 546 and 547.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22826) (level 0) is not >= the key value in the parent (1:23522) slot 304.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22827) (level 0) is not >= the key value in the parent (1:23522) slot 305.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22828) (level 0) is not >= the key value in the parent (1:23522) slot 306.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22829) (level 0) is not >= the key value in the parent (1:23522) slot 307.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22830) (level 0) is not >= the key value in the parent (1:23522) slot 308.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22831) (level 0) is not >= the key value in the parent (1:23522) slot 309.Server: Msg 8933, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22832) (level 0) is not >= the key value in the parent (1:23522) slot 294.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 21. The high key value on page (1:22847) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:22832).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20555) (level 0) is not less than the low key value in the parent (1:20578), slot 27 of the next page (1:20556).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20556) (level 0) is not less than the low key value in the parent (1:20578), slot 28 of the next page (1:20557).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20557) (level 0) is not less than the low key value in the parent (1:20578), slot 29 of the next page (1:20558).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20558) (level 0) is not less than the low key value in the parent (1:20578), slot 30 of the next page (1:20559).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20559) (level 0) is not less than the low key value in the parent (1:20578), slot 31 of the next page (1:20544).Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 24. Keys out of order on page (1:20560), slots 332 and 333.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 24. Keys out of order on page (1:20560), slots 418 and 419.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 24. Keys out of order on page (1:20560), slots 546 and 547.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20568) (level 0) is not less than the low key value in the parent (1:20578), slot 8 of the next page (1:20569).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20569) (level 0) is not less than the low key value in the parent (1:20578), slot 9 of the next page (1:20570).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20570) (level 0) is not less than the low key value in the parent (1:20578), slot 10 of the next page (1:20571).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19467) (level 0) is not less than the low key value in the parent (1:19922), slot 297 of the next page (1:19468).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19468) (level 0) is not less than the low key value in the parent (1:19922), slot 298 of the next page (1:19469).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19469) (level 0) is not less than the low key value in the parent (1:19922), slot 299 of the next page (1:19470).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19470) (level 0) is not less than the low key value in the parent (1:19922), slot 300 of the next page (1:19471).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19471) (level 0) is not less than the low key value in the parent (1:19922), slot 301 of the next page (1:19456).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19472) (level 0) is not less than the low key value in the parent (1:19922), slot 286 of the next page (1:19473).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19480) (level 0) is not less than the low key value in the parent (1:19922), slot 278 of the next page (1:19481).Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 25. Keys out of order on page (1:19480), slots 417 and 418.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 25. Keys out of order on page (1:19480), slots 545 and 546.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19481) (level 0) is not less than the low key value in the parent (1:19922), slot 279 of the next page (1:19482).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19482) (level 0) is not less than the low key value in the parent (1:19922), slot 280 of the next page (1:19483).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19835) (level 0) is not less than the low key value in the parent (1:19922), slot 95 of the next page (1:19836).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19836) (level 0) is not less than the low key value in the parent (1:19922), slot 96 of the next page (1:19837).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19837) (level 0) is not less than the low key value in the parent (1:19922), slot 97 of the next page (1:19838).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19838) (level 0) is not less than the low key value in the parent (1:19922), slot 98 of the next page (1:19839).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19839) (level 0) is not less than the low key value in the parent (1:19922), slot 99 of the next page (1:19824).Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 25. Keys out of order on page (1:19840), slots 332 and 333.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19850) (level 0) is not less than the low key value in the parent (1:19922), slot 78 of the next page (1:19851).Server: Msg 8926, Level 16, State 1, Line 1Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1539757534, index ID 26, and page (1:18935), slot 0, in object ID 1539757534, index ID 27, next refer to page (1:18920) but are not in the same object.Server: Msg 8926, Level 16, State 1, Line 1Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1539757534, index ID 26, and page (1:18937), slot 0, in object ID 1539757534, index ID 27, next refer to page (1:18939) but are not in the same object.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18603) (level 0) is not less than the low key value in the parent (1:19066), slot 316 of the next page (1:18604).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18604) (level 0) is not less than the low key value in the parent (1:19066), slot 317 of the next page (1:18605).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18605) (level 0) is not less than the low key value in the parent (1:19066), slot 318 of the next page (1:18606).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18606) (level 0) is not less than the low key value in the parent (1:19066), slot 319 of the next page (1:18607).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18607) (level 0) is not less than the low key value in the parent (1:19066), slot 320 of the next page (1:18592).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18608) (level 0) is not less than the low key value in the parent (1:19066), slot 301 of the next page (1:18609).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18609) (level 0) is not less than the low key value in the parent (1:19066), slot 302 of the next page (1:18610).Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 26. Keys out of order on page (1:18610), slots 332 and 333.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18618) (level 0) is not less than the low key value in the parent (1:19066), slot 295 of the next page (1:18619).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18770) (level 0) is not less than the low key value in the parent (1:19066), slot 163 of the next page (1:18771).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18771) (level 0) is not less than the low key value in the parent (1:19066), slot 164 of the next page (1:18772).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18772) (level 0) is not less than the low key value in the parent (1:19066), slot 165 of the next page (1:18773).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18773) (level 0) is not less than the low key value in the parent (1:19066), slot 166 of the next page (1:18774).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. The high key value on page (1:18774) (level 0) is not less than the low key value in the parent (1:19066), slot 167 of the next page (1:18775).Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 26. Keys out of order on page (1:18775), slots 332 and 333.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18896) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18897) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18898) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18899) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18900) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18901) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18902) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18903) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18904) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18905) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18906) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18907) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18908) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18909) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18910) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18911) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18912) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18913) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18914) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18915) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18916) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18917) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18918) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18919) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18920) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18921) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18922) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18923) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18924) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18925) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18926) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18927) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18928) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18929) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18930) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18931) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18932) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8982, Level 16, State 1, Line 1Table error: Cross object linkage. Page (1:18932)->next in object ID 1539757534, index ID 26 refers to page (1:18933) in object ID 1539757534, index ID 27 but is not in the same index.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:18933) allocated to object ID 1539757534, index ID 26 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:18934) allocated to object ID 1539757534, index ID 26 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:18935) allocated to object ID 1539757534, index ID 26 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:18936) allocated to object ID 1539757534, index ID 26 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:18937) allocated to object ID 1539757534, index ID 26 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:18938) allocated to object ID 1539757534, index ID 26 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 8936, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree chain linkage mismatch. (1:18937)->next = (1:18939), but (1:18939)->Prev = (1:18938).Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18939) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18940) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18941) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18942) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 26. B-tree page (1:18943) has two parent nodes (0:1), slot 0 and (1:19066), slot 1.Server: Msg 8925, Level 16, State 1, Line 1Table error: Cross object linkage: Page (1:19066), slot 96, in object ID 1539757534, index ID 26, refers to page (1:18938), slot 0, in object ID 1539757534, index ID 27.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 270 refers to child page (1:5453) and previous child (1:18220), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 316 refers to child page (1:15276) and previous child (1:18153), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 345 refers to child page (1:15329) and previous child (1:18132), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 50 refers to child page (1:15680) and previous child (1:18890), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 338 refers to child page (1:15695) and previous child (1:18142), but they were not encountered.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. The high key value on page (1:18093) (level 0) is not less than the low key value in the parent (1:56099), slot 21 of the next page (1:18094).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. The high key value on page (1:18094) (level 0) is not less than the low key value in the parent (1:56099), slot 22 of the next page (1:18095).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. The high key value on page (1:18096) (level 0) is not less than the low key value in the parent (1:56099), slot 8 of the next page (1:18097).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. The high key value on page (1:18097) (level 0) is not less than the low key value in the parent (1:56099), slot 9 of the next page (1:18098).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. The high key value on page (1:18098) (level 0) is not less than the low key value in the parent (1:56099), slot 10 of the next page (1:18099).Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. The high key value on page (1:18099) (level 0) is not less than the low key value in the parent (1:56099), slot 11 of the next page (1:18100).Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 27. Keys out of order on page (1:18100), slots 333 and 334.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 27. Keys out of order on page (1:18100), slots 417 and 418.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1539757534, Index ID 27. Keys out of order on page (1:18100), slots 545 and 546.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 349 refers to child page (1:18120) and previous child (1:18135), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 340 refers to child page (1:18128) and previous child (1:18143), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 341 refers to child page (1:18129) and previous child (1:18128), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 342 refers to child page (1:18130) and previous child (1:18129), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 343 refers to child page (1:18131) and previous child (1:18130), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 344 refers to child page (1:18132) and previous child (1:18131), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 346 refers to child page (1:18133) and previous child (1:15329), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 347 refers to child page (1:18134) and previous child (1:18133), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 348 refers to child page (1:18135) and previous child (1:18134), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 331 refers to child page (1:18136) and previous child (1:18151), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 332 refers to child page (1:18137) and previous child (1:18136), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 333 refers to child page (1:18138) and previous child (1:18137), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 334 refers to child page (1:18139) and previous child (1:18138), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 335 refers to child page (1:18140) and previous child (1:18139), but they were not encountered.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1539757534, index ID 27. Index node page (1:18938), slot 336 refers to child page (1:18141) and previous child (1:18140), but they were not encountered.Server: Msg 8986, Level 16, State 1, Line 1Too many errors found (201) for object ID 1539757534. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS".There are 206953 rows in 4489 pages for object 'arTransaction'.CHECKDB found 0 allocation errors and 555 consistency errors in table 'arTransaction' (object ID 1539757534).DBCC results for 'a_admResStay'.There are 0 rows in 0 pages for object 'a_admResStay'.DBCC results for 'a_secUserAlertLink'.There are 0 rows in 0 pages for object 'a_secUserAlertLink'.DBCC results for 'arBPServiceAccountMatrix'.There are 268 rows in 1 pages for object 'arBPServiceAccountMatrix'.DBCC results for 'sysPGASubjects'.There are 17 rows in 1 pages for object 'sysPGASubjects'.DBCC results for 'admContactRole'.There are 6 rows in 1 pages for object 'admContactRole'.DBCC results for 'sysAuditCategory'.There are 70 rows in 1 pages for object 'sysAuditCategory'.DBCC results for 'arBPSrvcCatSplitMatrix'.There are 138 rows in 1 pages for object 'arBPSrvcCatSplitMatrix'.DBCC results for 'rptCaseMixCalcEditListSub'.There are 0 rows in 1 pages for object 'rptCaseMixCalcEditListSub'.DBCC results for 'sysRoomNum'.There are 1091 rows in 4 pages for object 'sysRoomNum'.DBCC results for 'arTransTemp'.There are 0 rows in 1 pages for object 'arTransTemp'.DBCC results for 'sysAuditCatLink'.There are 25 rows in 1 pages for object 'sysAuditCatLink'.DBCC results for 'arBPType'.There are 10 rows in 1 pages for object 'arBPType'.DBCC results for 'sysProcessType'.There are 34 rows in 1 pages for object 'sysProcessType'.DBCC results for 'sysRouteOfAdmin'.There are 15 rows in 1 pages for object 'sysRouteOfAdmin'.DBCC results for 'sysBuildingUnit'.There are 40 rows in 1 pages for object 'sysBuildingUnit'.DBCC results for 'a_admVitalsWeights'.There are 0 rows in 0 pages for object 'a_admVitalsWeights'.DBCC results for 'sysAuditCatTableLink'.There are 76 rows in 1 pages for object 'sysAuditCatTableLink'.DBCC results for 'arChargeBatchDetail'.There are 10 rows in 1 pages for object 'arChargeBatchDetail'.DBCC results for 'rptMDSActivitiesofDailyLiving'.There are 0 rows in 0 pages for object 'rptMDSActivitiesofDailyLiving'.DBCC results for 'a_sysUserDefQuesDesc'.There are 0 rows in 0 pages for object 'a_sysUserDefQuesDesc'.DBCC results for 'rptMDSAdvancedDirectives'.There are 0 rows in 0 pages for object 'rptMDSAdvancedDirectives'.DBCC results for 'sysReportLink'.There are 659 rows in 3 pages for object 'sysReportLink'.DBCC results for 'a_sysFeatCompanyLink'.There are 0 rows in 0 pages for object 'a_sysFeatCompanyLink'.DBCC results for 'arChargeSplitDetail'.There are 149 rows in 1 pages for object 'arChargeSplitDetail'.DBCC results for 'rptMDSDevicesandRestraints'.There are 0 rows in 0 pages for object 'rptMDSDevicesandRestraints'.DBCC results for 'sysRptOptionDetails'.There are 819 rows in 9 pages for object 'sysRptOptionDetails'.DBCC results for 'admPhyOrderAdmin'.There are 0 rows in 0 pages for object 'admPhyOrderAdmin'.DBCC results for 'sysLabelDefinitions'.There are 37 rows in 1 pages for object 'sysLabelDefinitions'.DBCC results for 'rptMDSResCensusAndConditions'.There are 711 rows in 11 pages for object 'rptMDSResCensusAndConditions'.DBCC results for 'admDosage'.There are 6 rows in 1 pages for object 'admDosage'.DBCC results for 'arChargeTemp'.There are 0 rows in 1 pages for object 'arChargeTemp'.DBCC results for 'sysScreens'.There are 499 rows in 9 pages for object 'sysScreens'.DBCC results for 'sysRXCode'.There are 4 rows in 1 pages for object 'sysRXCode'.DBCC results for 'admDrugClass'.There are 47 rows in 1 pages for object 'admDrugClass'.DBCC results for 'admProfessional'.There are 116 rows in 1 pages for object 'admProfessional'.DBCC results for 'a_sysUserDefQuesAns'.There are 0 rows in 0 pages for object 'a_sysUserDefQuesAns'.DBCC results for 'admResInsurance'.There are 1904 rows in 28 pages for object 'admResInsurance'.DBCC results for 'admResPGA'.There are 14611 rows in 429 pages for object 'admResPGA'.DBCC results for 'sysSchdCodePassTime'.There are 48 rows in 1 pages for object 'sysSchdCodePassTime'.DBCC results for 'arPAWorksheetDetail'.There are 0 rows in 0 pages for object 'arPAWorksheetDetail'.DBCC results for 'admResStay'.There are 1455 rows in 29 pages for object 'admResStay'.DBCC results for 'arTFBatch'.There are 2 rows in 1 pages for object 'arTFBatch'.DBCC results for 'arChargeSplit'.There are 76 rows in 1 pages for object 'arChargeSplit'.DBCC results for 'arTransMemo'.There are 52 rows in 1 pages for object 'arTransMemo'.DBCC results for 'sysFeatScreensLink'.There are 452 rows in 1 pages for object 'sysFeatScreensLink'.DBCC results for 'glAccountCategory'.There are 70 rows in 1 pages for object 'glAccountCategory'.DBCC results for 'admProfessionalType'.There are 16 rows in 1 pages for object 'admProfessionalType'.DBCC results for 'sysInfoUser'.There are 1 rows in 1 pages for object 'sysInfoUser'.DBCC results for 'glAccountSubCategory'.There are 31 rows in 1 pages for object 'glAccountSubCategory'.DBCC results for 'admVitalsWeights'.There are 20487 rows in 152 pages for object 'admVitalsWeights'.DBCC results for 'glDistributionDetail'.There are 0 rows in 0 pages for object 'glDistributionDetail'.DBCC results for 'sysReport'.There are 182 rows in 2 pages for object 'sysReport'.DBCC results for 'glBudget'.There are 5 rows in 1 pages for object 'glBudget'.DBCC results for 'apSettings'.There are 7 rows in 1 pages for object 'apSettings'.DBCC results for 'mdsSection'.There are 99 rows in 3 pages for object 'mdsSection'.DBCC results for 'glBudgetDetail'.There are 2332 rows in 11 pages for object 'glBudgetDetail'.DBCC results for 'arECSIntermediary'.There are 1 rows in 1 pages for object 'arECSIntermediary'.DBCC results for 'sysRptOptions'.There are 372 rows in 3 pages for object 'sysRptOptions'.DBCC results for 'glBudgetFixedDetail'.There are 27984 rows in 172 pages for object 'glBudgetFixedDetail'.DBCC results for 'glBudgetUnit'.There are 0 rows in 0 pages for object 'glBudgetUnit'.DBCC results for 'repUserReports'.There are 20 rows in 2 pages for object 'repUserReports'.DBCC results for 'glBudgetUnitDetail'.There are 0 rows in 0 pages for object 'glBudgetUnitDetail'.DBCC results for 'arHCPCCode'.There are 46 rows in 1 pages for object 'arHCPCCode'.DBCC results for 'arChargeTransfer'.There are 1017 rows in 4 pages for object 'arChargeTransfer'.DBCC results for 'glClosingHistory'.There are 25 rows in 1 pages for object 'glClosingHistory'.DBCC results for 'admResLiability'.There are 725 rows in 5 pages for object 'admResLiability'.DBCC results for 'arChargeTransLink'.There are 34620 rows in 159 pages for object 'arChargeTransLink'.DBCC results for 'rptResidentPasValue'.There are 1 rows in 1 pages for object 'rptResidentPasValue'.DBCC results for 'glClosingHistoryAction'.There are 2 rows in 1 pages for object 'glClosingHistoryAction'.DBCC results for 'sysShortCuts'.There are 35 rows in 1 pages for object 'sysShortCuts'.DBCC results for 'admResNoteDiscipline'.There are 19 rows in 1 pages for object 'admResNoteDiscipline'.DBCC results for 'rptCaseMixCalcEditList'.There are 0 rows in 1 pages for object 'rptCaseMixCalcEditList'.DBCC results for 'arECSBatchInfo'.There are 411 rows in 5 pages for object 'arECSBatchInfo'.DBCC results for 'glDepartment'.There are 24 rows in 1 pages for object 'glDepartment'.DBCC results for 'tblContSubTemp'.There are 0 rows in 0 pages for object 'tblContSubTemp'.DBCC results for 'sysResSumByProbRptDetails'.There are 20 rows in 3 pages for object 'sysResSumByProbRptDetails'.DBCC results for 'admResNoteType'.There are 18 rows in 1 pages for object 'admResNoteType'.DBCC results for 'rptFlowsheetOrders'.There are 0 rows in 0 pages for object 'rptFlowsheetOrders'.DBCC results for 'arECSBatchStmtLink'.There are 2956 rows in 8 pages for object 'arECSBatchStmtLink'.DBCC results for 'a_admContact'.There are 0 rows in 0 pages for object 'a_admContact'.DBCC results for 'ecsRecords'.There are 4947 rows in 1238 pages for object 'ecsRecords'.DBCC results for 'glDeptToMajorDeptLink'.There are 0 rows in 0 pages for object 'glDeptToMajorDeptLink'.DBCC results for 'tblDiagnosis'.There are 16449 rows in 175 pages for object 'tblDiagnosis'.DBCC results for 'sysUserDefQuesDesc'.There are 22 rows in 1 pages for object 'sysUserDefQuesDesc'.DBCC results for 'a_admContactTypeLink'.There are 0 rows in 0 pages for object 'a_admContactTypeLink'.DBCC results for 'rptResSumByProb'.There are 0 rows in 0 pages for object 'rptResSumByProb'.DBCC results for 'glDistributionCode'.There are 0 rows in 0 pages for object 'glDistributionCode'.DBCC results for 'sysRugsCategories'.There are 213 rows in 2 pages for object 'sysRugsCategories'.DBCC results for 'admAdmSource'.There are 9 rows in 1 pages for object 'admAdmSource'.DBCC results for 'a_admContPhone'.There are 0 rows in 0 pages for object 'a_admContPhone'.DBCC results for 'a_admAddress'.There are 0 rows in 0 pages for object 'a_admAddress'.DBCC results for 'rptSuggestedCarePlans'.There are 0 rows in 0 pages for object 'rptSuggestedCarePlans'.DBCC results for 'tblDosageTemp'.There are 0 rows in 0 pages for object 'tblDosageTemp'.DBCC results for 'arRXCharges'.There are 0 rows in 0 pages for object 'arRXCharges'.DBCC results for 'a_admPhyOrderPassTime'.There are 0 rows in 0 pages for object 'a_admPhyOrderPassTime'.DBCC results for 'rptSuggestedCarePlansTemp'.There are 0 rows in 0 pages for object 'rptSuggestedCarePlansTemp'.DBCC results for 'tblFDATemp'.There are 0 rows in 0 pages for object 'tblFDATemp'.DBCC results for 'sysSchdCodes'.There are 37 rows in 1 pages for object 'sysSchdCodes'.DBCC results for 'arStmtAdjmtUB04'.There are 0 rows in 0 pages for object 'arStmtAdjmtUB04'.DBCC results for 'admAdmType'.There are 5 rows in 1 pages for object 'admAdmType'.DBCC results for 'rptMDSAssmtDue_LOA'.There are 0 rows in 0 pages for object 'rptMDSAssmtDue_LOA'.DBCC results for 'a_admPhyOrders'.There are 0 rows in 0 pages for object 'a_admPhyOrders'.DBCC results for 'glHistory'.There are 0 rows in 0 pages for object 'glHistory'.DBCC results for 'tblMedFileTemp'.There are 0 rows in 0 pages for object 'tblMedFileTemp'.DBCC results for 'arStmtDetailCMS150085'.There are 0 rows in 0 pages for object 'arStmtDetailCMS150085'.DBCC results for 'secAccounts'.There are 7 rows in 1 pages for object 'secAccounts'.DBCC results for 'glHistoryEvent'.There are 0 rows in 0 pages for object 'glHistoryEvent'.DBCC results for 'tblNDCTemp'.There are 0 rows in 0 pages for object 'tblNDCTemp'.DBCC results for 'a_arStmtDetailCMS150085'.There are 0 rows in 0 pages for object 'a_arStmtDetailCMS150085'.DBCC results for 'arNote'.There are 3 rows in 1 pages for object 'arNote'.DBCC results for 'glJESource'.There are 6 rows in 1 pages for object 'glJESource'.DBCC results for 'tblRouteTemp'.There are 0 rows in 0 pages for object 'tblRouteTemp'.DBCC results for 'arStmtDetailUB04'.There are 3371 rows in 42 pages for object 'arStmtDetailUB04'.DBCC results for 'a_admProfLink2'.There are 0 rows in 0 pages for object 'a_admProfLink2'.DBCC results for 'admAddress'.There are 5017 rows in 53 pages for object 'admAddress'.DBCC results for 'glJETemplateTransaction'.There are 314 rows in 3 pages for object 'glJETemplateTransaction'.DBCC results for 'tblRXTemp'.There are 0 rows in 0 pages for object 'tblRXTemp'.DBCC results for 'a_arStmtDetailUB04'.There are 0 rows in 0 pages for object 'a_arStmtDetailUB04'.DBCC results for 'sysSoftwareVendor'.There are 1 rows in 1 pages for object 'sysSoftwareVendor'.DBCC results for 'glJEType'.There are 19 rows in 1 pages for object 'glJEType'.DBCC results for 'admAlert'.There are 203 rows in 8 pages for object 'admAlert'.DBCC results for 'admWarning'.There are 0 rows in 0 pages for object 'admWarning'.DBCC results for 'arStmtHeaderCMS150085'.There are 0 rows in 0 pages for object 'arStmtHeaderCMS150085'.DBCC results for 'sysStdOrders'.There are 16 rows in 1 pages for object 'sysStdOrders'.DBCC results for 'mdsRAPTriggers'.There are 20 rows in 4 pages for object 'mdsRAPTriggers'.DBCC results for 'admAlertUser'.There are 218 rows in 1 pages for object 'admAlertUser'.DBCC results for 'a_arStmtHeaderCMS150085'.There are 0 rows in 0 pages for object 'a_arStmtHeaderCMS150085'.DBCC results for 'arPaymentBatch'.There are 1 rows in 1 pages for object 'arPaymentBatch'.DBCC results for 'mdsReaction'.There are 300 rows in 9 pages for object 'mdsReaction'.DBCC results for 'glJournalEntry'.There are 1367 rows in 13 pages for object 'glJournalEntry'.DBCC results for 'a_admResAllergy'.There are 0 rows in 0 pages for object 'a_admResAllergy'.DBCC results for 'sysStdOrdersPassTimes'.There are 0 rows in 0 pages for object 'sysStdOrdersPassTimes'.DBCC results for 'admResUdAssess'.There are 3 rows in 1 pages for object 'admResUdAssess'.CHECKDB found 0 allocation errors and 570 consistency errors in database 'mycustdb'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (mycustdb ).DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-18 : 18:07:14
|
One line isToo many errors found (201) for object ID 1539757534. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS".Do a SELECT OBJECT_NAME(1539757534) to see what it is.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-18 : 18:10:33
|
quote:
2) Our custom maint plan includes a dbcc reindex every night and some tables have over 200000 records and a mess of constraints. Is this a potential problem?
You should only reindex the indexes that are fragmented. If you are using the reindex option from the maintenance plan, then it is reindexing all of them each time. This is a performance problem while the job is running. 200000 rows is not very many. Constraints are there to protect the data by constraining them to what the business requirement is. They do not cause corruption problems. I'm sure Paul will be able to give you some kind of idea why this happened. It is typically a hardware problem though, so if the hardware problem has not been resolved, the database corruption is likely to appear again.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
dprworld
Starting Member
4 Posts |
Posted - 2008-04-18 : 18:19:05
|
quote:
Originally posted by Peso
One line isToo many errors found (201) for object ID 1539757534. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS".Do a SELECT OBJECT_NAME(1539757534) to see what it is.
E 12°55'05.25"N 56°04'39.16"
This is the arTransaction table. About a 1000 records were lost, but I was able to recover them from an older backup. ThanksThe db is fixed...I'm really interested in prevention at this point. |
|
|
|
dprworld
Starting Member
4 Posts |
Posted - 2008-04-18 : 18:31:08
|
quote:
You should only reindex the indexes that are fragmented. If you are using the reindex option from the maintenance plan, then it is reindexing all of them each time. This is a performance problem while the job is running. ...I'm sure Paul will be able to give you some kind of idea why this happened. It is typically a hardware problem though, so if the hardware problem has not been resolved, the database corruption is likely to appear again.
Performance with the maint plan is not an issue at this point. Preventing corruption by whatever best practices available is what I'm looking for. Our customer is running on SQL 2000 Standard sp3 8.00.760. I alos noticed in their sql logs that they are using Backup exec or something to backup the system databases by evidence of the following. Should I have them remove this process as well??Thank you.Database model: IO is frozen for snapshot2008-04-16 23:00:54.56 spid64 Database msdb: IO is frozen for snapshot...2008-04-16 23:00:56.70 spid64 Database msdb: IO is thawed2008-04-16 23:00:56.70 spid60 Database model: IO is thawed |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-18 : 18:40:08
|
| You should have them remove it if you've got SQL backups in place to backup the system databases.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-04-18 : 19:28:24
|
| Hey,Do you have any idea why the corruption happened in the first place? You should take steps to make sure it doesn't happen again.For SQL 2000, here's what I'd recommend:1) turn on torn-page detection2) make sure there's a backup strategy in place that allows the database to be restored in accordance with whatever SLAs are agreed to (mostly in terms of downtime and data-loss). E.g. if you want up-to-the minute recovery you'd better be in FULL recovery model taking frequent log backups.3) make sure they're running some form of consistency checks regularly.If it's a VLDB, checkout http://www.sqlskills.com/blogs/paul/2007/11/19/CHECKDBFromEveryAngleConsistencyCheckingOptionsForAVLDB.aspxThe reindexing isn't a problem as far as corruption is concerned, but could be in terms of data and log space. That's a whole other conversation :-) Checkout the whitepaper at http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspxHope this helps.Paul RandalSQL Server MVP, Managing Director, SQLskills.com |
|
|
|
dprworld
Starting Member
4 Posts |
Posted - 2008-04-21 : 12:12:37
|
quote:
Originally posted by paulrandal
Do you have any idea why the corruption happened in the first place?
I don't know how it happened. The SQL logs and NT event logs didn't provide any clues.Thank you for the list and white paper links! BTW - We had another customer who had a similar problem. It somehow went away after completely removing SQL 2000 desktop sp3 and installing desktop sp4. I don't know if that is just a coincidence, but we battled with inconsistency errors for 3-4 weeks (occurring every couple days after cleaning them up). I was just about to have them reinstall on another server, but installing sp4 seemed to fix it. Unfortunately, I don't have any hard facts to prove it was sp3, but they have been running smoothly for a couple months now. |
|
|
|
|
|
|
|
|
Corruption anyone?