Msg 824 in SQL Server - 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

Msg 824 in SQL Server

Author

Topic

Mits
Starting Member

48 Posts

Posted - 2013-04-06 : 17:02:47

Hi

I am developer and new to SQL Server. We are using SQL Server 2008 R2 and recently i am getting following errors.

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x00000000; actual signature: 0x38203d60). It occurred during a read of page (1:2240128) in database ID 7 at offset 0x00000445d00000 in file 'D:\LiveWebsite\SQLDB\VF.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

I read on internet and ran DBCC checkdb. I have got the results but i am not sure how to analyse the log to pin point the corrupted tables.

I have got the backup of DB but not a clean one prior to getting this errors. I have attaced the results of DBCC Checkdb.

Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8412160578939125760 (type Unknown), page (1:2240096). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8431627719984480256 (type Unknown), page (2562:303566172). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2153232668127264768 (type Unknown), page (65522:2030439032). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7132289577369796608 (type Unknown), page (41951:1887729385). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7797623440568614912 (type Unknown), page (24913:1105251738). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8055213396263108608 (type Unknown), page (7956:-1908257711). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 1657509454024933376 (type Unknown), page (8796:-1120047100). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2692432819999473664 (type Unknown), page (17587:-2066993626). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8626575908248813568 (type Unknown), page (1:2240104). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -9005183832006918144 (type Unknown), page (46704:-1054509774). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1504451185603510272 (type Unknown), page ID (1:2240106) contains an incorrect page ID in its page header. The PageId in the page header = (39944:118969040).
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 3146556001005076480 (type Unknown), page (26183:-1290038611). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7258917288141062144 (type Unknown), page (2550:238301252). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4287411102228938752 (type Unknown), page (44261:-605678773). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4329211631246966784 (type Unknown), page (36846:-804604142). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -572619962521616384 (type Unknown), page (56373:782066909). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 622906258979815424 (type Unknown), page (1:2240112). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8661671964451995648 (type Unknown), page (49969:1298094176). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -7475287558769737728 (type Unknown), page (5912:1114982481). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8618317043423969280 (type Unknown), page (26295:-409711573). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4347896695996874752 (type Unknown), page (2372:-2029657033). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9034919118390755328 (type Unknown), page (4096:248204469). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -2085671439325986816 (type Unknown), page ID (1:2240118) contains an incorrect page ID in its page header. The PageId in the page header = (17100:1674060134).
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8541786794736680960 (type Unknown), page (1416:1700938541). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -4559282601775464448 (type Unknown), page (1:2240120). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1899679717971263488 (type Unknown), page ID (1:2240121) contains an incorrect page ID in its page header. The PageId in the page header = (38320:-1059637258).
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 71956802146336768 (type Unknown), page ID (1:2240122) contains an incorrect page ID in its page header. The PageId in the page header = (8360:185660294).
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -9114801744139583488 (type Unknown), page (59965:-676250289). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -4728665513999728640 (type Unknown), page (27730:415707761). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4611936706646573056 (type Unknown), page (1:2240128). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 20628232407220224 (type Unknown), page (25651:-241315940). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7106680404197441536 (type Unknown), page (1603:100749868). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.
CHECKDB found 0 allocation errors and 32 consistency errors not associated with any single object.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240096) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240097) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240098) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240099) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240100) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240101) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240102) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240103) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240104) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240105) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240106) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240107) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240108) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240109) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240110) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240111) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240112) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240113) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240114) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240115) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240116) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240117) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240118) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240119) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240120) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240121) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240122) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240123) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240124) could not be processed. See other errors for details.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Page (1:2240096) was not seen in the scan although its parent (1:1356704) and previous (1:1526789) refer to it. Check any previous errors.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 8 refers to child page (1:2240097) and previous child (1:2240096), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 9 refers to child page (1:2240098) and previous child (1:2240097), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 10 refers to child page (1:2240099) and previous child (1:2240098), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 11 refers to child page (1:2240100) and previous child (1:2240099), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 12 refers to child page (1:2240101) and previous child (1:2240100), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 13 refers to child page (1:2240102) and previous child (1:2240101), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 14 refers to child page (1:2240103) and previous child (1:2240102), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 15 refers to child page (1:2240104) and previous child (1:2240103), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 16 refers to child page (1:2240105) and previous child (1:2240104), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 17 refers to child page (1:2240106) and previous child (1:2240105), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 18 refers to child page (1:2240107) and previous child (1:2240106), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 19 refers to child page (1:2240108) and previous child (1:2240107), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 20 refers to child page (1:2240109) and previous child (1:2240108), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 21 refers to child page (1:2240110) and previous child (1:2240109), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 22 refers to child page (1:2240111) and previous child (1:2240110), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 23 refers to child page (1:2240112) and previous child (1:2240111), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 24 refers to child page (1:2240113) and previous child (1:2240112), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 25 refers to child page (1:2240114) and previous child (1:2240113), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 26 refers to child page (1:2240115) and previous child (1:2240114), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 27 refers to child page (1:2240116) and previous child (1:2240115), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 28 refers to child page (1:2240117) and previous child (1:2240116), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 29 refers to child page (1:2240118) and previous child (1:2240117), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 30 refers to child page (1:2240119) and previous child (1:2240118), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 31 refers to child page (1:2240120) and previous child (1:2240119), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 32 refers to child page (1:2240121) and previous child (1:2240120), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 33 refers to child page (1:2240122) and previous child (1:2240121), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 34 refers to child page (1:2240123) and previous child (1:2240122), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 35 refers to child page (1:2240124) and previous child (1:2240123), but they were not encountered.
CHECKDB found 0 allocation errors and 58 consistency errors in table 'sys.ifts_comp_fragment_1630628852_195760' (object ID 1709768623).
Msg 8928, Level 16, State 2, Line 2
Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data): Page (1:2240128) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data): Page (1:2240129) could not be processed. See other errors for details.
Msg 8928, Level 16, State 2, Line 2
Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data): Page (1:2240130) could not be processed. See other errors for details.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data). Page (1:2240128) was not seen in the scan although its parent (1:1714459) and previous (1:1821640) refer to it. Check any previous errors.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data). Index node page (1:1714459), slot 8 refers to child page (1:2240129) and previous child (1:2240128), but they were not encountered.
Msg 8980, Level 16, State 1, Line 2
Table error: Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data). Index node page (1:1714459), slot 9 refers to child page (1:2240130) and previous child (1:2240129), but they were not encountered.
CHECKDB found 0 allocation errors and 6 consistency errors in table 'sys.ifts_comp_fragment_1630628852_195761' (object ID 1725768680).
CHECKDB found 0 allocation errors and 96 consistency errors in database 'VF'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (VF).

So what does it look like? And I would really appreciate if anyone can shed some light on where to start fixing this errors and what would be my ideal route.

Kind regards

Mitesh

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2013-04-08 : 06:50:52

database VF has consistency errors.
If you have a clean recent backup,try to restore it.

mohammad.javeed.ahmed@gmail.com

Mits
Starting Member

48 Posts

Posted - 2013-04-08 : 07:45:17

I have got the backup of DB but not a clean one prior to getting this errors. As the db is simple mode so there are no transactional logs.

I have restored the backup on a different server and ran DBCC CHCKDB repair_allow_data_loss. Here are the results.

It still have 23 errors it could not repair. What are my options at this point??

DBCC CHCKDB repair_allow_data_loss

DBCC results for 'VF'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
Msg 8939, Level 16, State 98, Line 6

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -9114801744139583488 (type Unknown), page (59965:-676250289). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -9005183832006918144 (type Unknown), page (46704:-1054509774). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8661671964451995648 (type Unknown), page (49969:1298094176). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.
Could not repair this error.

Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8618317043423969280 (type Unknown), page (26295:-409711573). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -14.
Could not repair this error.

Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8055213396263108608 (type Unknown), page (7956:-1908257711). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -7475287558769737728 (type Unknown), page (5912:1114982481). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -4728665513999728640 (type Unknown), page (27730:415707761). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1.
Could not repair this error.

Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -572619962521616384 (type Unknown), page (56373:782066909). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 20628232407220224 (type Unknown), page (25651:-241315940). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.
Could not repair this error.

Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 1657509454024933376 (type Unknown), page (8796:-1120047100). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2153232668127264768 (type Unknown), page (65522:2030439032). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -14.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2692432819999473664 (type Unknown), page (17587:-2066993626). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 3146556001005076480 (type Unknown), page (26183:-1290038611). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -14.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4287411102228938752 (type Unknown), page (44261:-605678773). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4329211631246966784 (type Unknown), page (36846:-804604142). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4347896695996874752 (type Unknown), page (2372:-2029657033). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.
Could not repair this error.

Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7106680404197441536 (type Unknown), page (1603:100749868). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7132289577369796608 (type Unknown), page (41951:1887729385). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7258917288141062144 (type Unknown), page (2550:238301252). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7797623440568614912 (type Unknown), page (24913:1105251738). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8431627719984480256 (type Unknown), page (2562:303566172). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8541786794736680960 (type Unknown), page (1416:1700938541). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 6
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9034919118390755328 (type Unknown), page (4096:248204469). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -14.
Could not repair this error.

CHECKDB found 0 allocation errors and 96 consistency errors in database 'VF'.
CHECKDB fixed 0 allocation errors and 73 consistency errors in database 'VF'.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources