DB write error - SQL Server Forums

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.

All Forums

General SQL Server Forums

Data Corruption Issues

DB write error

Author

Topic

justinwang
Starting Member

3 Posts

Posted - 2005-08-10 : 21:28:24

Hi, Any info will be greatly appreciated to fix this issue.

I am getting the following errors in my event log.
Error: 823, Severity: 24, State: 2
I/O error 2(The system cannot find the file specified.) detected during read at offset 0x00000004f7e000 in file 'F:\Program Files\Microsoft SQL Server\MSSQL\Data\PENANG\wiptrack_targetpng_data2.ndf'.

I am getting these error when I run DBCC:

Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (3:9944) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9945) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9946) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9947) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9948) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9949) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9950) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9951) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10168) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10169) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10170) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10171) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10173) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10174) with latch type UP. 2(The system cannot find the file specified.) failed.
DBCC results for 'PNG_TARGET'.
Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (3:10175) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10176) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10177) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10178) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10179) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10180) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10181) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10182) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10183) with latch type UP. 2(The system cannot find the file specified.) failed.
CHECKDB found 0 allocation errors and 23 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 215 rows in 10 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 220 rows in 14 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1390 rows in 78 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 187 rows in 64 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 4 rows in 1 pages for object 'sysfiles1'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (1:87967) is missing a reference from previous page (3:10176). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (1:88969) is missing a reference from previous page (3:10183). Possible chain linkage problem.
DBCC results for 'syspermissions'.
There are 221 rows in 4 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 255 rows in 4 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 570 rows in 8 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 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 'TblReject'.
There are 396620 rows in 10949 pages for object 'TblReject'.
DBCC results for 'TblBoxGroup'.
There are 22669 rows in 380 pages for object 'TblBoxGroup'.
DBCC results for 'TblCustShipment'.
There are 4425 rows in 83 pages for object 'TblCustShipment'.
DBCC results for 'TblFlowDetail'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10176) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 10 refers to child page (3:10176) and previous child (3:10177), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10177) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (3:10177) was not seen in the scan although its parent (1:90702) and previous (1:87966) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10178) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 13 refers to child page (3:10178) and previous child (3:10179), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10179) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (3:10179) was not seen in the scan although its parent (1:90702) and previous (1:87967) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10180) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 14 refers to child page (3:10180) and previous child (3:10178), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10181) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 15 refers to child page (3:10181) and previous child (3:10180), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10182) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 16 refers to child page (3:10182) and previous child (3:10181), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10183) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 17 refers to child page (3:10183) and previous child (3:10182), but they were not encountered.
There are 523629 rows in 9233 pages for object 'TblFlowDetail'.
CHECKDB found 0 allocation errors and 18 consistency errors in table 'TblFlowDetail' (object ID 421576540).
DBCC results for 'TblJob'.
There are 18895 rows in 623 pages for object 'TblJob'.
DBCC results for 'TblRejectDetailCross'.
There are 0 rows in 0 pages for object 'TblRejectDetailCross'.
DBCC results for 'TblStationChkPoint'.
There are 298610 rows in 6273 pages for object 'TblStationChkPoint'.
DBCC results for 'ci_control_TblBoxGroup'.
There are 0 rows in 1 pages for object 'ci_control_TblBoxGroup'.
DBCC results for 'ci_control_TblCustomer'.
There are 0 rows in 0 pages for object 'ci_control_TblCustomer'.
DBCC results for 'TblLine'.
There are 7 rows in 1 pages for object 'TblLine'.
DBCC results for 'ci_control_TblCustShipment'.
There are 0 rows in 1 pages for object 'ci_control_TblCustShipment'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:65650) is missing a reference from previous page (3:9950). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:80141) is missing a reference from previous page (3:9949). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:81931) is missing a reference from previous page (3:9948). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:88745) is missing a reference from previous page (3:9944). Possible chain linkage problem.
DBCC results for 'ci_control_TblDefect'.
There are 0 rows in 1 pages for object 'ci_control_TblDefect'.
DBCC results for 'ci_control_TblFlowDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblFlowDetail'.
DBCC results for 'TblStationQty'.
There are 487814 rows in 8946 pages for object 'TblStationQty'.
DBCC results for 'TblMachine'.
There are 5 rows in 1 pages for object 'TblMachine'.
DBCC results for 'ci_control_TblJob'.
There are 0 rows in 1 pages for object 'ci_control_TblJob'.
DBCC results for 'ci_control_TblJobDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblJobDetail'.
DBCC results for 'TblOperator'.
There are 470 rows in 7 pages for object 'TblOperator'.
DBCC results for 'ci_control_TblLine'.
There are 0 rows in 0 pages for object 'ci_control_TblLine'.
DBCC results for 'TblOperatorGroup'.
There are 22 rows in 1 pages for object 'TblOperatorGroup'.
DBCC results for 'TblTransaction'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:91159) is missing a reference from previous page (3:9945). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:95791) is missing a reference from previous page (3:9951). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:857249) is missing a reference from previous page (3:9946). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9630) is missing a reference from previous page (3:9947). Possible chain linkage problem.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9944) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9944) was not seen in the scan although its parent (1:86516) and previous (3:10996) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9945) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9945) was not seen in the scan although its parent (1:862260) and previous (1:81719) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9946) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9946) was not seen in the scan although its parent (1:2888) and previous (1:39804) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9947) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9947) was not seen in the scan although its parent (1:858889) and previous (1:84220) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9948) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9948) was not seen in the scan although its parent (1:51120) and previous (1:81279) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9949) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9949) was not seen in the scan although its parent (1:81180) and previous (1:79351) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9950) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9950) was not seen in the scan although its parent (1:51120) and previous (1:65448) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9951) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9951) was not seen in the scan although its parent (1:60668) and previous (1:87177) refer to it. Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:921) is missing a reference from previous page (3:10169). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:17475) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:55333) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:58600) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:66724) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:73049) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:73183) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:77526) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:80853) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:82680) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:83104) is missing a reference from previous page (3:10170). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:83310) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:85752) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:87603) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:91416) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:91418) is missing a reference from previous page (3:10173). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:92037) was not encountered.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:92278) is missing references from parent (unknown) and previous (page (3:10168)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:94476) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:98109) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:99231) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:100289) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:103626) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:104154) is missing a reference from previous page (3:10175). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:104303) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:107339) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:110106) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:985785) is missing a reference from previous page (3:10174). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989636) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989637) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989638) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989639) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989640) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989641) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989642) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989643) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989644) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989645) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989646) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989647) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989648) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989649) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989650) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989651) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989652) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989653) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989654) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989655) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989656) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989657) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989658) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989659) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989660) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989661) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989662) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989663) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989664) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989665) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989666) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989667) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989668) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989669) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989670) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989671) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989672) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989673) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989674) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989675) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989676) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989677) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:990949) is missing a reference from previous page (3:10171). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (3:4460) was not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10168) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. The next pointer of (1:83310) refers to page (3:10168). Neither (3:10168) nor its parent were encountered. Possible bad chain linkage.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10169) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10169) was not seen in the scan although its parent (1:9152) and previous (1:989626) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10170) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10170) was not seen in the scan although its parent (1:76565) and previous (1:83980) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10171) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10171) was not seen in the scan although its parent (1:925) and previous (1:34912) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10173) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10173) was not seen in the scan although its parent (1:76565) and previous (1:78785) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10174) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10174) was not seen in the scan although its parent (1:985742) and previous (1:80575) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10175) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10175) was not seen in the scan although its parent (1:88169) and previous (1:83978) refer to it. Check any previous errors.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (3:10339) was not encountered.
There are 4277643 rows in 97804 pages for object 'TblTransaction'.
CHECKDB found 0 allocation errors and 111 consistency errors in table 'TblTransaction' (object ID 768057822).
DBCC results for 'ci_control_TblLot'.
There are 0 rows in 1 pages for object 'ci_control_TblLot'.
DBCC results for 'ci_control_TblMachine'.
There are 0 rows in 0 pages for object 'ci_control_TblMachine'.
DBCC results for 'ci_control_TblOperator'.
There are 0 rows in 1 pages for object 'ci_control_TblOperator'.
DBCC results for 'ci_control_TblOperatorGroup'.
There are 0 rows in 0 pages for object 'ci_control_TblOperatorGroup'.
DBCC results for 'TtmpTransaction'.
There are 0 rows in 0 pages for object 'TtmpTransaction'.
DBCC results for 'TblCPQWeekNbr'.
There are 53 rows in 1 pages for object 'TblCPQWeekNbr'.
DBCC results for 'ci_control_TblPartDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblPartDetail'.
DBCC results for 'TblCPQYearNbr'.
There are 180 rows in 1 pages for object 'TblCPQYearNbr'.
DBCC results for 'TblKitModSNRship'.
There are 472666 rows in 5462 pages for object 'TblKitModSNRship'.
DBCC results for 'ci_control_TblPartSupplier'.
There are 0 rows in 0 pages for object 'ci_control_TblPartSupplier'.
DBCC results for 'TblShift'.
There are 3 rows in 1 pages for object 'TblShift'.
DBCC results for 'ci_control_TblReject'.
There are 0 rows in 1 pages for object 'ci_control_TblReject'.
DBCC results for 'ci_control_TblRejectDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblRejectDetail'.
DBCC results for 'ci_control_TblShift'.
There are 0 rows in 0 pages for object 'ci_control_TblShift'.
DBCC results for 'ci_control_TblStation'.
There are 0 rows in 1 pages for object 'ci_control_TblStation'.
DBCC results for 'ci_control_TblStationChkPoint'.
There are 0 rows in 1 pages for object 'ci_control_TblStationChkPoint'.
DBCC results for 'ci_control_TblStationQty'.
There are 3 rows in 1 pages for object 'ci_control_TblStationQty'.
DBCC results for 'ci_control_TblTester'.
There are 0 rows in 0 pages for object 'ci_control_TblTester'.
DBCC results for 'ci_control_TblTransaction'.
There are 0 rows in 1 pages for object 'ci_control_TblTransaction'.
DBCC results for 'TblCustomer'.
There are 7 rows in 1 pages for object 'TblCustomer'.
DBCC results for 'TblTester'.
There are 16 rows in 1 pages for object 'TblTester'.
DBCC results for 'ci_control_TblKitModSNRship'.
There are 0 rows in 1 pages for object 'ci_control_TblKitModSNRship'.
DBCC results for 'ci_control_TblSystemBuild'.
There are 1 rows in 1 pages for object 'ci_control_TblSystemBuild'.
DBCC results for 'TblRejectDetail'.
There are 104402 rows in 2403 pages for object 'TblRejectDetail'.
DBCC results for 'TblJobDetail'.
There are 1107946 rows in 23608 pages for object 'TblJobDetail'.
DBCC results for 'TblPartSupplier'.
There are 79 rows in 1 pages for object 'TblPartSupplier'.
DBCC results for 'TblDefect'.
There are 21113 rows in 337 pages for object 'TblDefect'.
DBCC results for 'png_ci_TblRowCount'.
There are 24 rows in 1 pages for object 'png_ci_TblRowCount'.
DBCC results for 'TblTbSetup'.
There are 1 rows in 1 pages for object 'TblTbSetup'.
DBCC results for 'TblStationQty1'.
There are 61755 rows in 974 pages for object 'TblStationQty1'.
DBCC results for 'TtmpStationProdLoad'.
There are 57 rows in 1 pages for object 'TtmpStationProdLoad'.
DBCC results for 'TblPartDetail'.
There are 3053 rows in 93 pages for object 'TblPartDetail'.
DBCC results for 'TblLot'.
There are 515677 rows in 11268 pages for object 'TblLot'.
DBCC results for 'TblStation'.
There are 474 rows in 11 pages for object 'TblStation'.
DBCC results for 'TblSystemBuild'.
There are 128623 rows in 2362 pages for object 'TblSystemBuild'.
DBCC results for 'dtproperties'.
There are 0 rows in 1 pages for object 'dtproperties'.
DBCC results for 'TblEqMaster'.
There are 0 rows in 1 pages for object 'TblEqMaster'.
DBCC results for 'TblEqMasterSNRShip'.
There are 0 rows in 1 pages for object 'TblEqMasterSNRShip'.
CHECKDB found 0 allocation errors and 152 consistency errors in database 'PNG_TARGET'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PNG_TARGET ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

ryanston
Microsoft SQL Server Product Team

89 Posts

Posted - 2005-08-11 : 13:25:04

It looks like you have some hardware problems.

As the early CHECKDB messages indicate, we're trying to read from file ID 3 ('F:\Program Files\Microsoft SQL Server\MSSQL\Data\PENANG\wiptrack_targetpng_data2.ndf'), and cannot find it.

Have you checked your system event log for SAN/disk errors?

Thanks,

----------------------
Ryan Stonecipher
Developer, Microsoft SQL Server Storage Engine, DBCC
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

justinwang
Starting Member

3 Posts

Posted - 2005-08-11 : 14:39:21

Hi,

I am running on IBM x345 server with Raid 5. No disk errors show up in the windows event log or the IBM serveraid manager logs. I have 3 other databases on the same partition with no read or write problems.

The specified missing .ndf file is there on the hard-drive. I am no SQL expert, is there a way to fix or test for corruption problems in just the .ndf file or is that file part of the DB.

ryanston
Microsoft SQL Server Product Team

89 Posts

Posted - 2005-08-12 : 10:41:07

Very strange. The operating system is telling us that it can't find the file we're asking for, so either the OS is having trouble locating a perfectly-good file, or we're telling the OS to go find the wrong one. Can you post the output from sysfiles for this database? I'll keep digging on this side.

Thanks,

----------------------
Ryan Stonecipher
Developer, Microsoft SQL Server Storage Engine, DBCC
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

justinwang
Starting Member

3 Posts

Posted - 2005-08-18 : 19:11:15

Thanks for the info. The 2nd database file was corrupted. I stopped all SQL services and I could not even copy that database's flat file to another drive, it errored out. We just did a complete restore and all is working again.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources