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 |
|
ongdennis
Starting Member
4 Posts |
 Posted - 2006-03-22 : 03:26:46
|
hi all...my prod database facing the problem i mention. it show this error when i run some of the query.Error: 823, Severity: 24, State: 2I/O error (torn page) detected during read at offset 0x000000ffd0e000 in file 'F:\dsUnit'.i running dbcc checkdb on it. this is the resultDBCC results for 'dsActive3'.DBCC results for 'sysobjects'.There are 472 rows in 8 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 728 rows in 39 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 4243 rows in 106 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 281 rows in 66 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 7 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 2776 rows in 18 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 26 rows in 1 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 4 rows in 1 pages for object 'sysfilegroups'.DBCC results for 'INSTRUCTION'.There are 0 rows in 0 pages for object 'INSTRUCTION'.DBCC results for 'DATASWEEP_CODES'.There are 180 rows in 4 pages for object 'DATASWEEP_CODES'.DBCC results for 'DATASWEEP_SEQUENCE'.There are 7 rows in 1 pages for object 'DATASWEEP_SEQUENCE'.DBCC results for 'OPERATION'.There are 52 rows in 1 pages for object 'OPERATION'.DBCC results for 'Results'.There are 2 rows in 1 pages for object 'Results'.DBCC results for 'DC_BLOB'.There are 8 rows in 1 pages for object 'DC_BLOB'.DBCC results for 'PRODUCTION_LINE'.There are 2 rows in 1 pages for object 'PRODUCTION_LINE'.DBCC results for 'DS_PERSISTENT_OBJECT'.There are 5 rows in 1 pages for object 'DS_PERSISTENT_OBJECT'.DBCC results for 'EQUIPMENT'.There are 0 rows in 0 pages for object 'EQUIPMENT'.DBCC results for 'RESOURCE_CONDITION'.There are 2 rows in 1 pages for object 'RESOURCE_CONDITION'.DBCC results for 'IMAGE_BLOB'.There are 0 rows in 0 pages for object 'IMAGE_BLOB'.DBCC results for 'ROUTE'.There are 125 rows in 2 pages for object 'ROUTE'.DBCC results for 'JOB_CONFIG'.There are 19 rows in 1 pages for object 'JOB_CONFIG'.DBCC results for 'UNIT_CHECKLIST'.There are 0 rows in 0 pages for object 'UNIT_CHECKLIST'.DBCC results for 'JOB_SCHEDULE'.There are 10 rows in 1 pages for object 'JOB_SCHEDULE'.DBCC results for 'LOCATION'.There are 1 rows in 1 pages for object 'LOCATION'.DBCC results for 'WORK_ORDER_ITEMS'.There are 4375 rows in 139 pages for object 'WORK_ORDER_ITEMS'.DBCC results for 'NOTE_BLOB'.There are 0 rows in 0 pages for object 'NOTE_BLOB'.DBCC results for 'ROUTE_STEP'.There are 599 rows in 13 pages for object 'ROUTE_STEP'.DBCC results for 'PART'.There are 1827 rows in 69 pages for object 'PART'.Server: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610106) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610106). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610107) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610107). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610165) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610165). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610166) could not be processed. See other errors for details.Server: Msg 8935, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. The previous link (5:611693) on page (5:610224) does not match the previous page (5:610106) that the parent (5:614865), slot 80 expects for this page.DBCC results for 'DS_TABLESPACE_MAP'.There are 6 rows in 1 pages for object 'DS_TABLESPACE_MAP'.DBCC results for 'BOM_PART_LIST'.There are 9927 rows in 196 pages for object 'BOM_PART_LIST'.DBCC results for 'SITE_INFO'.There are 1 rows in 1 pages for object 'SITE_INFO'.DBCC results for 'RESOURCE_ARC'.There are 2 rows in 1 pages for object 'RESOURCE_ARC'.DBCC results for 'CARRIER_COMPARTMENT'.There are 0 rows in 0 pages for object 'CARRIER_COMPARTMENT'.DBCC results for 'RESOURCE_QUEUE'.There are 2 rows in 1 pages for object 'RESOURCE_QUEUE'.DBCC results for 'TRX_BASE'.Server: Msg 8936, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. B-tree chain linkage mismatch. (5:610618)->next = (5:610224), but (5:610224)->Prev = (5:611693).Server: Msg 8981, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. The next pointer of (5:610619) refers to page (5:610343). Neither (5:610343) nor its parent were encountered. Possible bad chain linkage.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. The high key value on page (5:610616) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (5:610618).Server: Msg 8935, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. The previous link (5:611693) on page (5:610618) does not match the previous page (5:610616) that the parent (5:614865), slot 94 expects for this page.Server: Msg 8936, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. B-tree chain linkage mismatch. (5:610616)->next = (5:610618), but (5:610618)->Prev = (5:611693).Server: Msg 8935, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. The previous link (5:611693) on page (5:610619) does not match the previous page (5:610618) that the parent (5:614865), slot 95 expects for this page.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. Page (5:610619) is missing a reference from previous page (5:611693). Possible chain linkage problem.Server: Msg 8935, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. The previous link (5:611693) on page (5:610620) does not match the previous page (5:610619) that the parent (5:614865), slot 96 expects for this page.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. Page (5:610620) is missing a reference from previous page (5:611693). Possible chain linkage problem.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 1. Page (5:610622) is missing a reference from previous page (5:610620). Possible chain linkage problem.Server: Msg 8928, Level 16, State 1, Line 1Object ID 587149137, index ID 0: Page (4:523911) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 587149137, index ID 0, page (4:523911). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.There are 67236767 rows in 2321938 pages for object 'TRX_BASE'.CHECKDB found 0 allocation errors and 18 consistency errors in table 'TRX_BASE' (object ID 475148738).DBCC results for 'CHECKLIST_ITEM'.There are 0 rows in 0 pages for object 'CHECKLIST_ITEM'.DBCC results for 'DCS_LIST'.There are 0 rows in 0 pages for object 'DCS_LIST'.DBCC results for 'DCS_PARM'.There are 253 rows in 7 pages for object 'DCS_PARM'.DBCC results for 'RESOURCE_QUEUE_LINK'.There are 2 rows in 1 pages for object 'RESOURCE_QUEUE_LINK'.DBCC results for 'RESOURCE_ROUTE'.There are 1 rows in 1 pages for object 'RESOURCE_ROUTE'.DBCC results for 'DS_OBJECT_BLOB'.There are 45 rows in 1 pages for object 'DS_OBJECT_BLOB'.DBCC results for 'TEST_INSTANCE'.There are 5836487 rows in 159046 pages for object 'TEST_INSTANCE'.DBCC results for 'FORM_BLOB'.There are 647 rows in 4 pages for object 'FORM_BLOB'.DBCC results for 'ROUTE_ARC'.There are 1047 rows in 9 pages for object 'ROUTE_ARC'.DBCC results for 'UNIT'.There are 5139230 rows in 309518 pages for object 'UNIT'.CHECKDB found 0 allocation errors and 2 consistency errors in table 'UNIT' (object ID 587149137).DBCC results for 'INSTRUCTION_BLOB'.There are 0 rows in 0 pages for object 'INSTRUCTION_BLOB'.DBCC results for 'ROUTE_QUEUE'.There are 599 rows in 5 pages for object 'ROUTE_QUEUE'.DBCC results for 'INSTRUCTION_LIST'.There are 0 rows in 0 pages for object 'INSTRUCTION_LIST'.DBCC results for 'LOT'.There are 313 rows in 12 pages for object 'LOT'.DBCC results for 'ROUTE_QUEUE_LINK'.There are 599 rows in 9 pages for object 'ROUTE_QUEUE_LINK'.DBCC results for 'SCHEMA_VERSION'.There are 2 rows in 1 pages for object 'SCHEMA_VERSION'.DBCC results for 'PRODUCT_ROUTE_P_LINE_REL'.There are 0 rows in 0 pages for object 'PRODUCT_ROUTE_P_LINE_REL'.DBCC results for 'SERIAL_NUMBER'.There are 1 rows in 1 pages for object 'SERIAL_NUMBER'.DBCC results for 'PRODUCT_RS_WC_REL'.There are 0 rows in 0 pages for object 'PRODUCT_RS_WC_REL'.DBCC results for 'RESOURCE_STEP'.There are 2 rows in 1 pages for object 'RESOURCE_STEP'.DBCC results for 'STATION'.There are 53 rows in 1 pages for object 'STATION'.DBCC results for 'SUBROUTINE_BLOB'.There are 354 rows in 2 pages for object 'SUBROUTINE_BLOB'.DBCC results for 'TMPL_TBOM'.There are 2 rows in 1 pages for object 'TMPL_TBOM'.DBCC results for 'TBOM_PART_LIST'.There are 0 rows in 0 pages for object 'TBOM_PART_LIST'.DBCC results for 'TMPL_TBOM_PART_LIST'.There are 0 rows in 0 pages for object 'TMPL_TBOM_PART_LIST'.DBCC results for 'TRX_CARRIER'.There are 0 rows in 0 pages for object 'TRX_CARRIER'.DBCC results for 'TRACKED_OBJECT_HISTORY'.There are 18576505 rows in 922365 pages for object 'TRACKED_OBJECT_HISTORY'.DBCC results for 'TRX_CONSUMPTION'.There are 0 rows in 0 pages for object 'TRX_CONSUMPTION'.DBCC results for 'TRACKED_OBJECT_STATUS'.There are 5461496 rows in 587509 pages for object 'TRACKED_OBJECT_STATUS'.DBCC results for 'TRX_GENEALOGY'.There are 0 rows in 0 pages for object 'TRX_GENEALOGY'.DBCC results for 'XFR_DELETION_LOG'.There are 21699 rows in 279 pages for object 'XFR_DELETION_LOG'.DBCC results for 'UNIT_CHECKLIST_ITEM'.There are 0 rows in 0 pages for object 'UNIT_CHECKLIST_ITEM'.DBCC results for 'XFR_EXTRACT_LOG'.There are 7150 rows in 289 pages for object 'XFR_EXTRACT_LOG'.DBCC results for 'DS_LIST_ITEM'.There are 800 rows in 11 pages for object 'DS_LIST_ITEM'.DBCC results for 'HIERARCHY_LEVEL'.There are 10 rows in 5 pages for object 'HIERARCHY_LEVEL'.DBCC results for 'XFR_LOAD_LOG'.There are 0 rows in 0 pages for object 'XFR_LOAD_LOG'.DBCC results for 'XFR_SCHEMA_OBJECT'.There are 87 rows in 2 pages for object 'XFR_SCHEMA_OBJECT'.DBCC results for 'XFR_UPDATE_RELATIONSHIPS'.There are 37 rows in 1 pages for object 'XFR_UPDATE_RELATIONSHIPS'.DBCC results for 'BOX'.There are 305676 rows in 7968 pages for object 'BOX'.DBCC results for 'USER_SEQUENCE'.There are 0 rows in 0 pages for object 'USER_SEQUENCE'.DBCC results for 'DC_dst_CorrectiveAction'.There are 0 rows in 0 pages for object 'DC_dst_CorrectiveAction'.DBCC results for 'ACCOUNT'.There are 1 rows in 1 pages for object 'ACCOUNT'.DBCC results for 'DC_dst_ShiftDefinition'.There are 0 rows in 0 pages for object 'DC_dst_ShiftDefinition'.DBCC results for 'DC_dst_5DX'.There are 0 rows in 0 pages for object 'DC_dst_5DX'.DBCC results for 'XFR_INTERVAL_ID'.There are 10327 rows in 27 pages for object 'XFR_INTERVAL_ID'.DBCC results for 'DC_dst_ComponentLocation'.There are 0 rows in 0 pages for object 'DC_dst_ComponentLocation'.DBCC results for 'PROCESS_CONTROL'.There are 0 rows in 0 pages for object 'PROCESS_CONTROL'.DBCC results for 'DC_dst_Account'.There are 0 rows in 0 pages for object 'DC_dst_Account'.DBCC results for 'REFERENCE_DESIGNATOR'.There are 9927 rows in 51 pages for object 'REFERENCE_DESIGNATOR'.DBCC results for 'DC_dst_PasteMeasurement'.There are 0 rows in 0 pages for object 'DC_dst_PasteMeasurement'.DBCC results for 'TEST_DEFINITION'.There are 4 rows in 1 pages for object 'TEST_DEFINITION'.DBCC results for 'DC_dst_ReportActionLog'.There are 0 rows in 0 pages for object 'DC_dst_ReportActionLog'.DBCC results for 'DC_dst_CAR_NCR'.There are 0 rows in 0 pages for object 'DC_dst_CAR_NCR'.DBCC results for 'TEST_RESULT'.There are 10376737 rows in 199778 pages for object 'TEST_RESULT'.DBCC results for 'DC_dst_NonConObject'.There are 0 rows in 0 pages for object 'DC_dst_NonConObject'.DBCC results for 'DEFECT_REPAIR_ENTRY'.There are 3240433 rows in 169991 pages for object 'DEFECT_REPAIR_ENTRY'.DBCC results for 'DC_dstr_UserFormAndReports'.There are 4 rows in 1 pages for object 'DC_dstr_UserFormAndReports'.DBCC results for 'SITE_CONFIG'.There are 1 rows in 1 pages for object 'SITE_CONFIG'.DBCC results for 'DC_dst_NonConformance'.There are 0 rows in 0 pages for object 'DC_dst_NonConformance'.DBCC results for 'BOM'.There are 173 rows in 4 pages for object 'BOM'.DBCC results for 'DC_dstr_GroupSecurity'.There are 1 rows in 1 pages for object 'DC_dstr_GroupSecurity'.DBCC results for 'DC_dst_RMA_SerialNumber'.There are 82197 rows in 7129 pages for object 'DC_dst_RMA_SerialNumber'.DBCC results for 'SUBROUTINE'.There are 354 rows in 10 pages for object 'SUBROUTINE'.DBCC results for 'DC_dst_DPMO_Information'.There are 0 rows in 0 pages for object 'DC_dst_DPMO_Information'.DBCC results for 'TBOM'.There are 5139874 rows in 64048 pages for object 'TBOM'.DBCC results for 'DC_dst_LineSchedule'.There are 0 rows in 0 pages for object 'DC_dst_LineSchedule'.DBCC results for 'DC_dst_ECO_Details'.There are 0 rows in 0 pages for object 'DC_dst_ECO_Details'.DBCC results for 'HN_dst_PartDimension'.There are 1053 rows in 19 pages for object 'HN_dst_PartDimension'.DBCC results for 'DC_dst_ECO_Header'.There are 0 rows in 0 pages for object 'DC_dst_ECO_Header'.DBCC results for 'WORK_CENTER'.There are 0 rows in 0 pages for object 'WORK_CENTER'.DBCC results for 'ICT_Tester_Name'.There are 39 rows in 1 pages for object 'ICT_Tester_Name'.DBCC results for 'WORK_ORDER'.There are 4397 rows in 164 pages for object 'WORK_ORDER'.DBCC results for 'DS_LIST'.There are 72 rows in 2 pages for object 'DS_LIST'.DBCC results for 'HN_dst_StationDimension'.There are 1 rows in 1 pages for object 'HN_dst_StationDimension'.DBCC results for 'HIERARCHY'.There are 2 rows in 1 pages for object 'HIERARCHY'.DBCC results for 'CARRIER'.There are 0 rows in 0 pages for object 'CARRIER'.DBCC results for 'CHECKLIST'.There are 1 rows in 1 pages for object 'CHECKLIST'.DBCC results for 'DBPS'.There are 1 rows in 1 pages for object 'DBPS'.DBCC results for 'DCS'.There are 17 rows in 1 pages for object 'DCS'.DBCC results for 'APP_USER'.There are 2078 rows in 197 pages for object 'APP_USER'.DBCC results for 'DS_OBJECT'.There are 45 rows in 2 pages for object 'DS_OBJECT'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'CHECKOUT_ITEM'.There are 0 rows in 0 pages for object 'CHECKOUT_ITEM'.DBCC results for 'FORM'.There are 647 rows in 15 pages for object 'FORM'.DBCC results for 'CONSUMED_PART'.There are 0 rows in 0 pages for object 'CONSUMED_PART'.CHECKDB found 0 allocation errors and 20 consistency errors in database 'dsActive3'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (dsActive3 ).DBCC execution completed. If DBCC printed error messages, contact your system administrator.now the main problem is when i restore the latest backup i have. it also facing the problem. the other backup i got is one more week older than this.can anyone help me? i cant affort to has 2 week data loss  |
|
|
ongdennis
Starting Member
4 Posts |
Posted - 2006-03-22 : 03:37:46
|
| this is the result i get after i run this commanddbcc checkdb('dsActive3') with no_infomsgsServer: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610106) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610106). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610107) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610107). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610165) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610165). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610166) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610166). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 587149137, index ID 0: Page (4:523911) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 587149137, index ID 0, page (4:523911). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.CHECKDB found 0 allocation errors and 8 consistency errors in table 'TRX_BASE' (object ID 475148738).CHECKDB found 0 allocation errors and 2 consistency errors in table 'UNIT' (object ID 587149137).CHECKDB found 0 allocation errors and 10 consistency errors in database 'dsActive3'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (dsActive3 ). |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-03-22 : 05:20:31
|
| Can you restore most recent full backup to another environment (test), and see if this problem exists there?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-03-22 : 05:24:57
|
| Lesson to be learnt - take more regular backups. I'd agree with trying to restore somewhere else, in case this is a hardware dependant issue.Otherwise you're limited to restoring, running the dbcc with allow data loss and trying to manually pick through the tables to see what is missing.-------Moo. :) |
|
|
|
ongdennis
Starting Member
4 Posts |
Posted - 2006-03-22 : 06:14:47
|
| ya...already try thatit appear the same problemthe other set backup i have is on 12 marchalmost 2 week data lost.somemore the restore take more than 12 hours :(i able to find out the row causing torn page. do u all think is possible for me to del the row n reset the database status?another info is my database still can run now. it didnt show suspect status yet. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-03-22 : 07:19:34
|
| sounds like you may have to run, as Mr Mist suggested, dbbcc checkdb REPAIR_ALLOW_DATA_LOSS*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-03-22 : 12:29:53
|
quote:
i able to find out the row causing torn page. do u all think is possible for me to del the row n reset the database status?another info is my database still can run now. it didnt show suspect status yet.
Nope - you've got corrupt pages, not corrupt rows. Your choices are to restore or repair. Running repair will delete some pages from the table object_name(475148738) and so any constraints you have involving that table may be broken and any inherent business logic you have involving that table may also be broken.You should also work out why the torn page occured in the first place. Did you take a power outage? If not, you've got hardware problems and the issue will most likely happen again. If this is the case, I recommened you run hardware diagnostics and check all relevant firmware revs.ThanksPaul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-03-22 : 16:00:09
|
| Sadly, given that previous backups have this problem, it would seem to indicate that the problem may have occurred some time in the past. I had this, we tracked back and were able to determine the data issue had occurred between 25 Dec and 26 Dec the previous year, which meant we narrowed it down to a SAN failure.Lesson from that - after major hardware issue (especially SAN) prioritize a scheduled, detail dbcc checkdb of databases - where the output is reviewed. Our production DBA had scheduled jobs, but wasn;t revieweing the output (grrr)*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-03-22 : 17:53:22
|
| Hopefully he's not your prod DBA any more...Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
ongdennis
Starting Member
4 Posts |
Posted - 2006-03-22 : 19:40:05
|
| any method i can trace what table object (475148738) is that? i had finish runnning the dbbcc checkdb REPAIR_ALLOW_DATA_LOSS on my test server. it seem to be working fine. any fast method to find what is missing?thanks.. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-03-23 : 02:58:34
|
quote:
Originally posted by paulrandal
Hopefully he's not your prod DBA any more...Paul Randal
I think the euphamism is "He's in the market" .... *##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-03-23 : 02:59:53
|
quote:
Originally posted by ongdennis
any method i can trace what table object (475148738) is that? i had finish runnning the dbbcc checkdb REPAIR_ALLOW_DATA_LOSS on my test server. it seem to be working fine. any fast method to find what is missing?thanks..
... iirc select object_name(475148738)*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-03-23 : 03:02:03
|
quote:
Originally posted by ongdennis
this is the result i get after i run this commanddbcc checkdb('dsActive3') with no_infomsgsServer: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610106) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610106). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610107) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610107). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610165) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610165). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 475148738, index ID 0: Page (5:610166) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 475148738, index ID 0, page (5:610166). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 587149137, index ID 0: Page (4:523911) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 587149137, index ID 0, page (4:523911). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.CHECKDB found 0 allocation errors and 8 consistency errors in table 'TRX_BASE' (object ID 475148738).CHECKDB found 0 allocation errors and 2 consistency errors in table 'UNIT' (object ID 587149137).CHECKDB found 0 allocation errors and 10 consistency errors in database 'dsActive3'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (dsActive3 ).
*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
|
|
|
torn page error :(