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 |
|
jvillamin
Starting Member
1 Post |
 Posted - 2009-02-21 : 14:25:00
|
| I need help from you guys. I'm new to SQL Server 2000, and I had never encountered this error for about a year. I run a DBCC CHECKDB('cic-a,') and I got these errors.DBCC results for 'cic-am'.DBCC results for 'sysobjects'.There are 234 rows in 4 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 361 rows in 15 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 1242 rows in 23 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 155 rows in 16 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 50 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 20 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 309 rows in 2 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 0 rows in 0 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 'tblAsmtEmailMonitor'.There are 69793 rows in 338 pages for object 'tblAsmtEmailMonitor'.DBCC results for 'tblBranches'.There are 21 rows in 1 pages for object 'tblBranches'.DBCC results for 'tblAsmtWorkExperience'.There are 184324 rows in 4010 pages for object 'tblAsmtWorkExperience'.DBCC results for 'tblAttendees'.There are 0 rows in 0 pages for object 'tblAttendees'.DBCC results for 'tblBPIAccounts'.There are 0 rows in 0 pages for object 'tblBPIAccounts'.DBCC results for 'tblCallReference'.There are 0 rows in 0 pages for object 'tblCallReference'.DBCC results for 'tblCalls'.There are 0 rows in 0 pages for object 'tblCalls'.DBCC results for 'tblCallsIncoming'.There are 0 rows in 0 pages for object 'tblCallsIncoming'.DBCC results for 'tblCallsStatus'.There are 0 rows in 0 pages for object 'tblCallsStatus'.DBCC results for 'tblCIC'.There are 0 rows in 0 pages for object 'tblCIC'.DBCC results for 'tblCityOrTown'.There are 374 rows in 2 pages for object 'tblCityOrTown'.DBCC results for 'tblCompany'.There are 1 rows in 1 pages for object 'tblCompany'.DBCC results for 'tblContracts'.There are 0 rows in 0 pages for object 'tblContracts'.DBCC results for 'tblContractType'.There are 0 rows in 0 pages for object 'tblContractType'.DBCC results for 'tblCourse'.There are 0 rows in 0 pages for object 'tblCourse'.DBCC results for 'tblDayValue'.There are 0 rows in 0 pages for object 'tblDayValue'.DBCC results for 'tblDegree'.There are 0 rows in 0 pages for object 'tblDegree'.DBCC results for 'tblDepartment'.There are 11 rows in 1 pages for object 'tblDepartment'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'tblDocuments'.There are 0 rows in 0 pages for object 'tblDocuments'.DBCC results for 'tblEducationalLevels'.There are 6 rows in 1 pages for object 'tblEducationalLevels'.DBCC results for 'tblEmployers'.There are 0 rows in 0 pages for object 'tblEmployers'.DBCC results for 'tblEntryType'.There are 0 rows in 0 pages for object 'tblEntryType'.DBCC results for 'tblFAQ'.There are 10 rows in 1 pages for object 'tblFAQ'.DBCC results for 'tblFinanceCo'.There are 0 rows in 0 pages for object 'tblFinanceCo'.DBCC results for 'tblIA'.There are 0 rows in 0 pages for object 'tblIA'.DBCC results for 'tblIACoverLetter'.There are 0 rows in 0 pages for object 'tblIACoverLetter'.DBCC results for 'tblIADeleted'.There are 0 rows in 0 pages for object 'tblIADeleted'.DBCC results for 'tblIADependents'.There are 0 rows in 0 pages for object 'tblIADependents'.DBCC results for 'tblIADocSubmitted'.There are 0 rows in 0 pages for object 'tblIADocSubmitted'.DBCC results for 'tblIAEducation'.There are 0 rows in 0 pages for object 'tblIAEducation'.DBCC results for 'tblIAEvaluation'.There are 0 rows in 0 pages for object 'tblIAEvaluation'.DBCC results for 'tblIAInterview'.There are 0 rows in 0 pages for object 'tblIAInterview'.DBCC results for 'tblIAJobDescription'.There are 0 rows in 0 pages for object 'tblIAJobDescription'.DBCC results for 'tblIAJobDescriptionReview'.There are 0 rows in 0 pages for object 'tblIAJobDescriptionReview'.DBCC results for 'tblIAPayments'.There are 0 rows in 0 pages for object 'tblIAPayments'.DBCC results for 'tblIAProgramPayments'.There are 0 rows in 0 pages for object 'tblIAProgramPayments'.DBCC results for 'tblIAPrograms'.There are 0 rows in 0 pages for object 'tblIAPrograms'.DBCC results for 'tblIARelatives'.There are 0 rows in 0 pages for object 'tblIARelatives'.DBCC results for 'tblIARequiredPaperList'.There are 0 rows in 0 pages for object 'tblIARequiredPaperList'.DBCC results for 'tblIAWorkExperience'.There are 0 rows in 0 pages for object 'tblIAWorkExperience'.DBCC results for 'tblIndustry'.There are 0 rows in 0 pages for object 'tblIndustry'.DBCC results for 'tblInfoSource'.There are 0 rows in 0 pages for object 'tblInfoSource'.DBCC results for 'tblLinkCategory'.There are 9 rows in 1 pages for object 'tblLinkCategory'.DBCC results for 'tblLinkCategory_10252K'.There are 7 rows in 1 pages for object 'tblLinkCategory_10252K'.DBCC results for 'tblLinks'.There are 78 rows in 2 pages for object 'tblLinks'.DBCC results for 'tblLinks_10252K'.There are 61 rows in 1 pages for object 'tblLinks_10252K'.DBCC results for 'tblLinks_old'.There are 0 rows in 0 pages for object 'tblLinks_old'.DBCC results for 'tblMajor'.There are 0 rows in 0 pages for object 'tblMajor'.DBCC results for 'tblNews'.There are 60 rows in 1 pages for object 'tblNews'.DBCC results for 'tblNewsCategory'.There are 4 rows in 1 pages for object 'tblNewsCategory'.DBCC results for 'tblAsmtAutoAssessment'.There are 47169 rows in 345 pages for object 'tblAsmtAutoAssessment'.DBCC results for 'tblNewsLetter'.There are 3 rows in 1 pages for object 'tblNewsLetter'.DBCC results for 'tblNewsLetterArticles'.There are 17 rows in 1 pages for object 'tblNewsLetterArticles'.DBCC results for 'tblNOC'.There are 0 rows in 0 pages for object 'tblNOC'.DBCC results for 'tblAsmtMailMarketing'.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1058102810, index ID 255: Page (1:66014) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 1058102810, index ID 255, page (1:66014). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:66273), slot 18, text ID 30948196352 is not referenced.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1058102810, index ID 255: Page (1:72294) could not be processed. See other errors for details.There are 956 rows in 7 pages for object 'tblAsmtMailMarketing'.DBCC results for 'tblOffices'.There are 139 rows in 2 pages for object 'tblOffices'.DBCC results for 'tblPermitVISA'.There are 0 rows in 0 pages for object 'tblPermitVISA'.DBCC results for 'tblPhotoGallery'.There are 402 rows in 9 pages for object 'tblPhotoGallery'.DBCC results for 'tblProvince'.There are 84 rows in 1 pages for object 'tblProvince'.DBCC results for 'tblProvincialInfo'.There are 12 rows in 1 pages for object 'tblProvincialInfo'.DBCC results for 'tblReceipts'.There are 0 rows in 0 pages for object 'tblReceipts'.DBCC results for 'tblAsmtEducation'.There are 161627 rows in 3195 pages for object 'tblAsmtEducation'.DBCC results for 'tblRegions'.There are 0 rows in 0 pages for object 'tblRegions'.DBCC results for 'tblRelationships'.There are 0 rows in 0 pages for object 'tblRelationships'.DBCC results for 'tblSearchOptions'.There are 0 rows in 0 pages for object 'tblSearchOptions'.DBCC results for 'tblSeminars'.There are 10 rows in 1 pages for object 'tblSeminars'.DBCC results for 'tblAsmtPersonal'.Server: Msg 8939, Level 16, State 98, Line 1Table error: Object ID 1058102810, index ID 255, page (1:72294). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:110715), slot 0, text ID 30316429312 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:110740), slot 0, text ID 30317608960 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:110741), slot 0, text ID 30317608960 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:110742), slot 0, text ID 30317608960 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:111805), slot 0, text ID 30628642816 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:111806), slot 0, text ID 30628642816 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:111807), slot 0, text ID 30628642816 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:117870), slot 0, text ID 30893015040 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:117871), slot 0, text ID 30893015040 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:117872), slot 0, text ID 30893015040 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118063), slot 5, text ID 30923620352 is not referenced.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1058102810, index ID 255: Page (1:118179) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 1058102810, index ID 255, page (1:118179). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118184), slot 0, text ID 30931353600 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118216), slot 0, text ID 30939611136 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118217), slot 0, text ID 30939611136 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118218), slot 0, text ID 30939611136 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118231), slot 3, text ID 30952718336 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118248), slot 0, text ID 30944722944 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118275), slot 0, text ID 30948196352 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118290), slot 0, text ID 30948851712 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118291), slot 0, text ID 30948851712 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118292), slot 0, text ID 30948851712 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118331), slot 0, text ID 30952718336 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118332), slot 0, text ID 30952718336 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118333), slot 0, text ID 30952718336 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118640), slot 0, text ID 30991319040 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118641), slot 0, text ID 30991319040 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118642), slot 0, text ID 30991319040 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118643), slot 0, text ID 30991319040 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:118644), slot 0, text ID 30991319040 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:121126), slot 0, text ID 31018844160 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1058102810. The text, ntext, or image node at page (1:121748), slot 0, text ID 31056658432 is not referenced.There are 57545 rows in 3686 pages for object 'tblAsmtPersonal'.CHECKDB found 0 allocation errors and 38 consistency errors in table 'tblAsmtPersonal' (object ID 1058102810).DBCC results for 'tblSeminars_10252K'.There are 0 rows in 0 pages for object 'tblSeminars_10252K'.DBCC results for 'tblSeminarSked'.There are 190 rows in 9 pages for object 'tblSeminarSked'.DBCC results for 'tblServices'.There are 0 rows in 0 pages for object 'tblServices'.DBCC results for 'tblStatusCode'.There are 0 rows in 0 pages for object 'tblStatusCode'.DBCC results for 'tblUserCategory'.There are 2 rows in 1 pages for object 'tblUserCategory'.DBCC results for 'tblUsers'.There are 15 rows in 1 pages for object 'tblUsers'.DBCC results for 'tblUsers_061201'.There are 33 rows in 1 pages for object 'tblUsers_061201'.DBCC results for 'tblUsers_mayette'.There are 6 rows in 1 pages for object 'tblUsers_mayette'.DBCC results for 'tblVISA'.There are 0 rows in 0 pages for object 'tblVISA'.DBCC results for 'NOCClassification'.There are 42813 rows in 628 pages for object 'NOCClassification'.DBCC results for 'xxxtblBranches'.There are 6 rows in 1 pages for object 'xxxtblBranches'.DBCC results for 'tblAutoAssess'.There are 104 rows in 1 pages for object 'tblAutoAssess'.DBCC results for 'tblAsmtEvaluation'.There are 57859 rows in 1051 pages for object 'tblAsmtEvaluation'.DBCC results for 'tblEmailBlaster1'.There are 0 rows in 0 pages for object 'tblEmailBlaster1'.DBCC results for 'tblAsmtAssessmentSubCat'.There are 2 rows in 1 pages for object 'tblAsmtAssessmentSubCat'.DBCC results for 'tblAsmtSubCatHistory'.There are 18 rows in 1 pages for object 'tblAsmtSubCatHistory'.DBCC results for 'tblStatusCategory'.There are 4 rows in 1 pages for object 'tblStatusCategory'.DBCC results for 'tblStatus'.There are 21 rows in 1 pages for object 'tblStatus'.DBCC results for 'Country'.There are 0 rows in 0 pages for object 'Country'.DBCC results for 'EmployeesPhoto'.There are 124 rows in 3 pages for object 'EmployeesPhoto'.DBCC results for 'tblAccountChart'.There are 0 rows in 0 pages for object 'tblAccountChart'.DBCC results for 'tblApplicants'.There are 0 rows in 0 pages for object 'tblApplicants'.DBCC results for 'tblAppointments'.There are 0 rows in 0 pages for object 'tblAppointments'.DBCC results for 'tblIAStatus'.There are 10 rows in 1 pages for object 'tblIAStatus'.DBCC results for 'tblAsmtAssessment'.There are 11 rows in 1 pages for object 'tblAsmtAssessment'.DBCC results for 'tblAsmtCorrespondence'.There are 111950 rows in 1534 pages for object 'tblAsmtCorrespondence'.DBCC results for 'tblAsmtDuplicateCounter'.There are 8556 rows in 23 pages for object 'tblAsmtDuplicateCounter'.DBCC results for 'tblAsmtDuplicates'.There are 2210673 rows in 13273 pages for object 'tblAsmtDuplicates'.DBCC results for 'tblAsmtEmail'.There are 55 rows in 1 pages for object 'tblAsmtEmail'.CHECKDB found 0 allocation errors and 38 consistency errors in database 'cic-am'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (cic-am ).DBCC execution completed. If DBCC printed error messages, contact your system administrator.Thanks. |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2009-02-23 : 20:25:57
|
| You can restore from your backups (best choice) or you can run repair - in which case you'll lose some data from the tblAsmtPersonal table (and possibly screw up any business logic/foreign-key constraints you have involving that table. Third alternative is to create a new database and export all the data into the uncorrupt database. Last choice is to manually select from the tblAsmtPersonal table until you find the row that has the corrupt text values - that way you'll at least know what data is corrupt.Restoring from your backups is the only way to avoid data loss in that table, but if they're too old, you may not want to do that. If you can find out what data will be deleted, and you're able to recreate it, maybe repair is the way to go. It all depends on what your business can accept.ThanksPS This was caused by your I/O subsystem corrupting the data - do some root-cause analysis to figure out why.Paul S. Randal, Managing Director, SQLskills.com (www.SQLskills.com/blogs/paul)SQL Server MVP, Contributing Editor of TechNet MagazineAuthor of SQL 2005 DBCC CHECKDB/repair codeAuthor & Instructor of Microsoft Certified Master - Database course |
 |
|
|
|
|
|
|
|
HOW TO FIX CONSISTENCY ERRORS