February 15, 2012 at 2:57 am
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:429), slot 18, text ID 23442554880 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:596), slot 12, text ID 7164985344 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1183), slot 0, text ID 28164751360 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1215), slot 1, text ID 4729208832 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2530), slot 13, text ID 7170031616 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2530), slot 24, text ID 23350870016 is not referenced.
Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:2538) could not be processed. See other errors for details.
Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 2, index ID 255, page (1:2538). Test (m_freeCnt == freeCnt) failed. Values are 4989 and 5069.
CHECKDB found 0 allocation errors and 8 consistency errors in table 'sysindexes' (object ID 2).
Msg 8928, Level 16, State 1, Line 1
Object ID 804965994, index ID 0: Page (1:36216) could not be processed. See other errors for details.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 804965994, index ID 0, page (1:36216), row 11. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 28 and 9.
Msg 8934, Level 16, State 3, Line 1
Table error: Object ID 804965994, index ID 1. The high key value on page (1:109) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:11997).
Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 804965994, index ID 1. The low key value on page (1:11997) (level 0) is not >= the key value in the parent (1:10241) slot 0.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'LastLoginInfo_old' (object ID 804965994).
CHECKDB found 0 allocation errors and 12 consistency errors in database 'checkerpdatabase'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (checkerpdatabase ).
February 15, 2012 at 3:08 am
Got a clean backup? (a backup without the corruption)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 15, 2012 at 3:15 am
how to get the cleanup backup??????
please tell me
February 15, 2012 at 3:24 am
Errr, I'm talking about a regular, normal database backup. Do you have a backup that was taken before the corruption occurred? A backup that does not contain the corruption.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 15, 2012 at 3:39 am
i don't have database backup which is clean.my database on sql server 2000 what is the solution of the following i also installed hotfix information
February 15, 2012 at 3:40 am
how to remove all these error kinddly help
February 15, 2012 at 3:46 am
Then I do hope this is not a particularly important database.... You're going to lose some data
Put the database into single user mode and run the following (though I suspect it will fail)
DBCC CheckDB('checkerpdatabase',REPAIR_ALLOW_DATA_LOSS) WITH No_Infomsgs
Post any output.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 15, 2012 at 3:52 am
i have no problem with loosing data from database i want to recovered my database
when i run the following command which you provide
DBCC CHECKDB ('checkerpdatabase' ,REPAIR_REBUILD);
the following error occured
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 7170031616 owned by data record identified by RID = (1:658:5) id = 1144443201 and indid = 22.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 28164751360 owned by data record identified by RID = (1:660:5) id = 804965994 and indid = 6.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 28164882432 owned by data record identified by RID = (1:660:7) id = 804965994 and indid = 8.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 23326490624 owned by data record identified by RID = (1:690:24) id = 1921546029 and indid = 17.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 23350870016 owned by data record identified by RID = (1:988:7) id = 1617544946 and indid = 5.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 7164985344 owned by data record identified by RID = (1:990:13) id = 1144443201 and indid = 14.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 204722995200 owned by data record identified by RID = (1:1115:1) id = 1692741283 and indid = 3.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 23442554880 owned by data record identified by RID = (1:1167:4) id = 168491779 and indid = 5.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 15725756416 owned by data record identified by RID = (1:2077:12) id = 242204013 and indid = 5.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 23371841536 owned by data record identified by RID = (1:2590:26) id = 58587397 and indid = 2.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 4729208832 owned by data record identified by RID = (1:2591:1) id = 267916076 and indid = 2.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:429), slot 18, text ID 23442554880 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:596), slot 12, text ID 7164985344 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1183), slot 0, text ID 28164751360 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1215), slot 1, text ID 4729208832 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2530), slot 13, text ID 7170031616 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2530), slot 24, text ID 23350870016 is not referenced.
Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:2538) could not be processed. See other errors for details.
Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 2, index ID 255, page (1:2538). Test (m_freeCnt == freeCnt) failed. Values are 4989 and 5069.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 0, text ID 204722995200 is referenced by page (1:1144), slot 0, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 1, text ID 7164985344 is referenced by page (1:990), slot 13, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 6, text ID 23442554880 is referenced by page (1:1167), slot 4, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 7, text ID 15725756416 is referenced by page (1:2531), slot 8, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 9, text ID 7170031616 is referenced by page (1:658), slot 5, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 11, text ID 4729208832 is referenced by page (1:2591), slot 1, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 12, text ID 23326490624 is referenced by page (1:2419), slot 2, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 23, text ID 28164751360 is referenced by page (1:660), slot 5, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 24, text ID 28164882432 is referenced by page (1:1151), slot 1, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 25, text ID 23350870016 is referenced by page (1:988), slot 7, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 26, text ID 23371841536 is referenced by page (1:2590), slot 26, but was not seen in the scan.
CHECKDB found 0 allocation errors and 30 consistency errors in table 'sysindexes' (object ID 2).
Msg 8928, Level 16, State 1, Line 1
Object ID 804965994, index ID 0: Page (1:36216) could not be processed. See other errors for details.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 804965994, index ID 0, page (1:36216), row 11. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 28 and 9.
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 804965994, index ID 1. The high key value on page (1:109) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:11997).
Msg 8934, Level 16, State 3, Line 1
Table error: Object ID 804965994, index ID 1. The high key value on page (1:109) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:11997).
Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 804965994, index ID 1. The low key value on page (1:11997) (level 0) is not >= the key value in the parent (1:10241) slot 0.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 804965994, index ID 1. Page (1:36216) was not seen in the scan although its parent (1:10241) and previous (1:143) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 804965994, index ID 1. Page (1:36360) is missing a reference from previous page (1:36216). Possible chain linkage problem.
CHECKDB found 0 allocation errors and 7 consistency errors in table 'LastLoginInfo_old' (object ID 804965994).
CHECKDB found 0 allocation errors and 37 consistency errors in database 'checkerpdatabase'.
February 15, 2012 at 3:55 am
ahsan_mustafa33 (2/15/2012)
i have no problem with loosing data from database i want to recovered my databasewhen i run the following command which you provide
DBCC CHECKDB ('checkerpdatabase' ,REPAIR_REBUILD)
I did NOT say repair rebuild. It's not sufficient for the errors you have. If you ask for help and it's given then don't just ignore it.
Put the database into single user mode and run the following (though I suspect it will fail)
DBCC CheckDB('checkerpdatabase',REPAIR_ALLOW_DATA_LOSS) WITH No_Infomsgs
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 15, 2012 at 4:09 am
when i run the command the following error occured
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 7170031616 owned by data record identified by RID = (1:658:5) id = 1144443201 and indid = 22.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 28164751360 owned by data record identified by RID = (1:660:5) id = 804965994 and indid = 6.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 28164882432 owned by data record identified by RID = (1:660:7) id = 804965994 and indid = 8.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 23326490624 owned by data record identified by RID = (1:690:24) id = 1921546029 and indid = 17.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 23350870016 owned by data record identified by RID = (1:988:7) id = 1617544946 and indid = 5.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 7164985344 owned by data record identified by RID = (1:990:13) id = 1144443201 and indid = 14.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 204722995200 owned by data record identified by RID = (1:1115:1) id = 1692741283 and indid = 3.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 23442554880 owned by data record identified by RID = (1:1167:4) id = 168491779 and indid = 5.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 15725756416 owned by data record identified by RID = (1:2077:12) id = 242204013 and indid = 5.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 23371841536 owned by data record identified by RID = (1:2590:26) id = 58587397 and indid = 2.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 4729208832 owned by data record identified by RID = (1:2591:1) id = 267916076 and indid = 2.
The system cannot self repair this error.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:429), slot 18, text ID 23442554880 is not referenced.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:596), slot 12, text ID 7164985344 is not referenced.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1183), slot 0, text ID 28164751360 is not referenced.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1215), slot 1, text ID 4729208832 is not referenced.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2530), slot 13, text ID 7170031616 is not referenced.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2530), slot 24, text ID 23350870016 is not referenced.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:2538) could not be processed. See other errors for details.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 2, index ID 255, page (1:2538). Test (m_freeCnt == freeCnt) failed. Values are 4989 and 5069.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 0, text ID 204722995200 is referenced by page (1:1144), slot 0, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 1, text ID 7164985344 is referenced by page (1:990), slot 13, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 6, text ID 23442554880 is referenced by page (1:1167), slot 4, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 7, text ID 15725756416 is referenced by page (1:2531), slot 8, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 9, text ID 7170031616 is referenced by page (1:658), slot 5, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 11, text ID 4729208832 is referenced by page (1:2591), slot 1, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 12, text ID 23326490624 is referenced by page (1:2419), slot 2, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 23, text ID 28164751360 is referenced by page (1:660), slot 5, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 24, text ID 28164882432 is referenced by page (1:1151), slot 1, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 25, text ID 23350870016 is referenced by page (1:988), slot 7, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2538), slot 26, text ID 23371841536 is referenced by page (1:2590), slot 26, but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
CHECKDB found 0 allocation errors and 30 consistency errors in table 'sysindexes' (object ID 2).
Msg 8928, Level 16, State 1, Line 1
Object ID 804965994, index ID 0: Page (1:36216) could not be processed. See other errors for details.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 804965994, index ID 0, page (1:36216), row 11. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 28 and 9.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 804965994, index ID 1. The high key value on page (1:109) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:11997).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 804965994, index ID 1. The low key value on page (1:11997) (level 0) is not >= the key value in the parent (1:10241) slot 0.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 804965994, index ID 1. Page (1:36216) was not seen in the scan although its parent (1:10241) and previous (1:143) refer to it. Check any previous errors.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 804965994, index ID 1. Page (1:36360) is missing a reference from previous page (1:36216). Possible chain linkage problem.
The repair level on the DBCC statement caused this repair to be bypassed.
CHECKDB found 0 allocation errors and 6 consistency errors in table 'LastLoginInfo_old' (object ID 804965994).
CHECKDB found 0 allocation errors and 36 consistency errors in database 'checkerpdatabase'.
February 15, 2012 at 4:32 am
That was with REPAIR_ALLOW_DATA_LOSS?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 15, 2012 at 4:37 am
yes it was with that command
February 15, 2012 at 5:11 am
Then the errors you have are not repairable.
The only solution now is to recreate the database. Script all of the objects in the DB, export all data (there's a chance that some data and/or some objects) will fail, create a new database, recreate all of the objects and import all of the data
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 15, 2012 at 11:12 pm
Right after you get done with all of that, I strongly suggest you learn how to do backups, scheduled log backups, and how to use them to do point-in-time restores by practicing the restores at least once a month (we do a test restore every day!). Errors like this can happen for a thousand different reasons and without the proper backups, you end up doing a whole lot of extra work for something that should take about 15 minutes to fix on a 30 or 40 GB database.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2012 at 11:27 pm
is their any short method to remove all these errors otherwise i will lose my database which have 200 tables
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply