January 5, 2011 at 7:14 am
We have corruption on one of our Sharepoint databases (SQL Server 2000). We've run a DBCC REPAIR_ALLOW_DATA_LOSS on a test server and the output is below (dir names and leaf names removed):
Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.
DBCC results for '<dbname>'.
DBCC results for 'sysobjects'.
There are 529 rows in 11 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 188 rows in 8 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3516 rows in 54 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 28 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 698 rows in 206 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 18 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 13 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 6143 rows in 32 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 1 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 1 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 301518225408 owned by data record identified by RID = (1:1673852:13) SiteId = D7187BC0-42A8-471F-B5A0-E34808CAFF6F and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 301518290944 owned by data record identified by RID = (1:1673852:13) SiteId = D7187BC0-42A8-471F-B5A0-E34808CAFF6F and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 301518356480 owned by data record identified by RID = (1:1673852:13) SiteId = D7187BC0-42A8-471F-B5A0-E34808CAFF6F and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 301507018752 owned by data record identified by RID = (1:4455912:15) SiteId = A8380FDC-921C-438D-A184-67EC05B7140B and DirName = '<dirname>' and LeafName = '<leafname>
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 120336154624 owned by data record identified by RID = (1:7785459:9) SiteId = FA32B7C4-C2C3-43D5-8D29-C5224EC2DC3F and DirName = '<dirname>' and LeafName = '<leafname>
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 314912276480 owned by data record identified by RID = (1:7790766:7) SiteId = 7BA0E748-6B6D-41EE-A80C-233A94614F6A and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 314912342016 owned by data record identified by RID = (1:7790766:7) SiteId = 7BA0E748-6B6D-41EE-A80C-233A94614F6A and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 314909982720 owned by data record identified by RID = (1:7790766:8) SiteId = 7BA0E748-6B6D-41EE-A80C-233A94614F6A and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 314910048256 owned by data record identified by RID = (1:7790766:8) SiteId = 7BA0E748-6B6D-41EE-A80C-233A94614F6A and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 314910113792 owned by data record identified by RID = (1:7790766:8) SiteId = 7BA0E748-6B6D-41EE-A80C-233A94614F6A and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 301509378048 owned by data record identified by RID = (1:8331567:8) SiteId = 40B075ED-CD17-47DF-93E6-EDE8626DE96C and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 314907688960 owned by data record identified by RID = (1:8470263:17) SiteId = 726A74F2-A51F-425A-8404-93A0DF59C5B1 and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 314907754496 owned by data record identified by RID = (1:8470263:17) SiteId = 726A74F2-A51F-425A-8404-93A0DF59C5B1 and DirName = '<dirname>' and LeafName = '<leafname>'.
DBCC results for 'Sites'.
There are 516 rows in 31 pages for object 'Sites'.
DBCC results for 'Webs'.
There are 516 rows in 430 pages for object 'Webs'.
DBCC results for 'Categories'.
There are 0 rows in 0 pages for object 'Categories'.
DBCC results for 'WebCat'.
There are 6192 rows in 96 pages for object 'WebCat'.
DBCC results for 'Lists'.
There are 5147 rows in 623 pages for object 'Lists'.
DBCC results for 'UserData'.
There are 823247 rows in 138691 pages for object 'UserData'.
DBCC results for 'WebParts'.
There are 28314 rows in 996 pages for object 'WebParts'.
DBCC results for 'EventCache'.
There are 0 rows in 0 pages for object 'EventCache'.
DBCC results for 'EventLog'.
There are 0 rows in 0 pages for object 'EventLog'.
DBCC results for 'ImmedSubscriptions'.
There are 0 rows in 0 pages for object 'ImmedSubscriptions'.
DBCC results for 'SchedSubscriptions'.
There are 0 rows in 0 pages for object 'SchedSubscriptions'.
DBCC results for 'Personalization'.
There are 0 rows in 0 pages for object 'Personalization'.
DBCC results for 'WelcomeNames'.
There are 2 rows in 1 pages for object 'WelcomeNames'.
DBCC results for 'TimerLock'.
There are 1 rows in 1 pages for object 'TimerLock'.
DBCC results for 'DiskWarningDate'.
There are 1 rows in 1 pages for object 'DiskWarningDate'.
DBCC results for 'ComMd'.
There are 42 rows in 1 pages for object 'ComMd'.
DBCC results for 'UserInfo'.
There are 17858 rows in 610 pages for object 'UserInfo'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'WebMembers'.
There are 16872 rows in 165 pages for object 'WebMembers'.
DBCC results for 'SiteGroupMembership'.
There are 0 rows in 0 pages for object 'SiteGroupMembership'.
DBCC results for 'WebGroupMembership'.
There are 12421 rows in 90 pages for object 'WebGroupMembership'.
DBCC results for 'WebGroups'.
There are 2580 rows in 125 pages for object 'WebGroups'.
DBCC results for 'SiteGroups'.
There are 0 rows in 0 pages for object 'SiteGroups'.
DBCC results for 'SystemVersion'.
There are 1 rows in 1 pages for object 'SystemVersion'.
DBCC results for 'HT_Settings'.
There are 5 rows in 1 pages for object 'HT_Settings'.
DBCC results for 'HT_Cache'.
There are 0 rows in 0 pages for object 'HT_Cache'.
DBCC results for 'Deps'.
There are 69 rows in 4 pages for object 'Deps'.
DBCC results for 'Docs'.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 314907820032 owned by data record identified by RID = (1:8470263:17) SiteId = 726A74F2-A51F-425A-8404-93A0DF59C5B1 and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 312662818816 owned by data record identified by RID = (1:9907830:14) SiteId = 6104BB99-1030-4C9C-9285-958C88B8C25C and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 312662884352 owned by data record identified by RID = (1:9907830:14) SiteId = 6104BB99-1030-4C9C-9285-958C88B8C25C and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 301568819200 owned by data record identified by RID = (1:10138160:1) SiteId = 6104BB99-1030-4C9C-9285-958C88B8C25C and DirName = '<dirname>' and LeafName = '<leafname>
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 301568884736 owned by data record identified by RID = (1:10138160:1) SiteId = 6104BB99-1030-4C9C-9285-958C88B8C25C and DirName = '<dirname>' and LeafName = '<leafname>
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 315290615808 owned by data record identified by RID = (1:11937877:1) SiteId = 508120F8-4CFD-4B68-A046-BFEB1C59B123 and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 315290681344 owned by data record identified by RID = (1:11937877:1) SiteId = 508120F8-4CFD-4B68-A046-BFEB1C59B123 and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 315292909568 owned by data record identified by RID = (1:11946282:10) SiteId = 508120F8-4CFD-4B68-A046-BFEB1C59B123 and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 315292975104 owned by data record identified by RID = (1:11946282:10) SiteId = 508120F8-4CFD-4B68-A046-BFEB1C59B123 and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 315293040640 owned by data record identified by RID = (1:11946282:10) SiteId = 508120F8-4CFD-4B68-A046-BFEB1C59B123 and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 301522944000 owned by data record identified by RID = (1:17738338:7) SiteId = 6104BB99-1030-4C9C-9285-958C88B8C25C and DirName = '<dirname>' and LeafName = '<leafname>'.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9191128), slot 2, text ID 312662818816 is not referenced.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 255: Page (1:9583792) could not be processed. See other errors for details.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 1, text ID 301507018752 is referenced by page (1:4455912), slot 15, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 2, text ID 301509378048 is referenced by page (1:8331567), slot 8, but was not seen in the scan.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 255, page (1:9583792), row 3. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 65280 and 1121.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 4, text ID 301518225408 is referenced by page (1:1673852), slot 13, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 5, text ID 301518290944 is referenced by page (1:1673852), slot 13, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 6, text ID 301518356480 is referenced by page (1:1673852), slot 13, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 7, text ID 301522944000 is referenced by page (1:17738338), slot 7, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 8, text ID 301568819200 is referenced by page (1:10138160), slot 1, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 9, text ID 301568884736 is referenced by page (1:10138160), slot 1, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 16, text ID 312662818816 is referenced by page (1:9907830), slot 14, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 17, text ID 312662884352 is referenced by page (1:9907830), slot 14, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 19, text ID 314907688960 is referenced by page (1:8470263), slot 17, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 20, text ID 314907754496 is referenced by page (1:8470263), slot 17, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 21, text ID 314907820032 is referenced by page (1:8470263), slot 17, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 22, text ID 314909982720 is referenced by page (1:7790766), slot 8, but was not seen in the scan.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 23, text ID 314910048256 is referenced by page (1:7790766), slot 8, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 24, text ID 314910113792 is referenced by page (1:7790766), slot 8, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 25, text ID 314912276480 is referenced by page (1:7790766), slot 7, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 26, text ID 314912342016 is referenced by page (1:7790766), slot 7, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 27, text ID 315290615808 is referenced by page (1:11937877), slot 1, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 28, text ID 315290681344 is referenced by page (1:11937877), slot 1, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 30, text ID 315292909568 is referenced by page (1:11946282), slot 10, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 31, text ID 315292975104 is referenced by page (1:11946282), slot 10, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 32, text ID 315293040640 is referenced by page (1:11946282), slot 10, but was not seen in the scan.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9871194), slot 0, text ID 301507018752 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9871455), slot 0, text ID 301568884736 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10088545), slot 0, text ID 312662884352 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10088546), slot 0, text ID 312662884352 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10088547), slot 0, text ID 312662884352 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10088548), slot 0, text ID 312662884352 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153036), slot 1, text ID 314909982720 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153036), slot 2, text ID 314912276480 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153331), slot 0, text ID 314907754496 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153332), slot 0, text ID 314910048256 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153333), slot 0, text ID 314910048256 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153334), slot 0, text ID 314910048256 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153335), slot 0, text ID 314910048256 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10159975), slot 0, text ID 315290681344 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10159979), slot 0, text ID 315292975104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10159980), slot 0, text ID 315292975104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10159981), slot 0, text ID 315292975104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10159982), slot 0, text ID 315292975104 is not referenced.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 255: Page (1:10542555) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 255, page (1:10542555). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10542555), slot 0, text ID 120336154624 is referenced by page (1:10542531), slot 0, but was not seen in the scan.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:11926382), slot 15, text ID 315292975104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:13640409), slot 0, text ID 314910048256 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:13640410), slot 0, text ID 314912342016 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:19888540), slot 0, text ID 301518290944 is not referenced.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
Repair: Deleted text column, text ID 301518225408, for object ID 1993058136 on page (1:1673852), slot 13.
Repair: Deleted text column, text ID 301518290944, for object ID 1993058136 on page (1:1673852), slot 13.
Repair: Deleted text column, text ID 301518356480, for object ID 1993058136 on page (1:1673852), slot 13.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database '<dbname>', index 'Links.Links_Backward' (ID 2121058592) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:22736431:4) with values (SiteId = 5515C06E-0231-4A19-8BF9-885CE79178A9 and TargetDirName = '<dirname>' and TargetLeafName = NULL and SiteId = 5515C06E-0231-4A19-8BF9-885CE79178A9 and DirName = 'pe) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database '<dbname>', index 'Links.Links_Backward' (ID 2121058592) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:22736431:9) with values (SiteId = 5515C06E-0231-4A19-8BF9-885CE79178A9 and TargetDirName = '<dirname>' and TargetLeafName = NULL and SiteId = 5515C06E-0231-4A19-8BF9-885CE79178A9 and DirName = '<dirname>' and LeafName = '<leafname>) points to the data row identified by ().
Repair: Deleted text column, text ID 301507018752, for object ID 1993058136 on page (1:4455912), slot 15.
Repair: Deleted text column, text ID 120336154624, for object ID 1993058136 on page (1:7785459), slot 9.
Repair: Deleted text column, text ID 314912276480, for object ID 1993058136 on page (1:7790766), slot 7.
Repair: Deleted text column, text ID 314912342016, for object ID 1993058136 on page (1:7790766), slot 7.
Repair: Deleted text column, text ID 314909982720, for object ID 1993058136 on page (1:7790766), slot 8.
Repair: Deleted text column, text ID 314910048256, for object ID 1993058136 on page (1:7790766), slot 8.
Repair: Deleted text column, text ID 314910113792, for object ID 1993058136 on page (1:7790766), slot 8.
Repair: Deleted text column, text ID 301509378048, for object ID 1993058136 on page (1:8331567), slot 8.
Repair: Deleted text column, text ID 314907688960, for object ID 1993058136 on page (1:8470263), slot 17.
Repair: Deleted text column, text ID 314907754496, for object ID 1993058136 on page (1:8470263), slot 17.
Repair: Deleted text column, text ID 314907820032, for object ID 1993058136 on page (1:8470263), slot 17.
Repair: Deleted text column, text ID 312662818816, for object ID 1993058136 on page (1:9907830), slot 14.
Repair: Deleted text column, text ID 312662884352, for object ID 1993058136 on page (1:9907830), slot 14.
Repair: Deleted text column, text ID 301568819200, for object ID 1993058136 on page (1:10138160), slot 1.
Repair: Deleted text column, text ID 301568884736, for object ID 1993058136 on page (1:10138160), slot 1.
Repair: Deleted text column, text ID 315290615808, for object ID 1993058136 on page (1:11937877), slot 1.
Repair: Deleted text column, text ID 315290681344, for object ID 1993058136 on page (1:11937877), slot 1.
Repair: Deleted text column, text ID 315292909568, for object ID 1993058136 on page (1:11946282), slot 10.
Repair: Deleted text column, text ID 315292975104, for object ID 1993058136 on page (1:11946282), slot 10.
Repair: Deleted text column, text ID 315293040640, for object ID 1993058136 on page (1:11946282), slot 10.
Repair: Deleted text column, text ID 301522944000, for object ID 1993058136 on page (1:17738338), slot 7.
Repair: Page (1:9583792) has been deallocated from object ID 1993058136, index ID 255.
Repair: Page (1:10542555) has been deallocated from object ID 1993058136, index ID 255.
There are 868438 rows in 78804 pages for object 'Docs'.
CHECKDB found 0 allocation errors and 75 consistency errors in table 'Docs' (object ID 1993058136).
CHECKDB fixed 0 allocation errors and 75 consistency errors in table 'Docs' (object ID 1993058136).
DBCC results for 'DocVersions'.
There are 4689 rows in 122 pages for object 'DocVersions'.
DBCC results for 'Links'.
The error has been repaired.
The error has been repaired.
There are 179168 rows in 11717 pages for object 'Links'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'Links' (object ID 2121058592).
CHECKDB fixed 0 allocation errors and 2 consistency errors in table 'Links' (object ID 2121058592).
DBCC results for 'NavNodes'.
There are 7064 rows in 240 pages for object 'NavNodes'.
CHECKDB found 0 allocation errors and 77 consistency errors in database '<dbname>'.
CHECKDB fixed 0 allocation errors and 77 consistency errors in database '<dbname>'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
It is encouraging that all errors have been fixed, but is there any way to determine exactly which data loss has occurred following the repair?
Also, we've seen various suggestions that DBCC REPAIR_ALLOW_DATA_LOSS should not be run on a SharePoint database, including here: http://support.microsoft.com/kb/841057/en-us , so we're currently debating whether this is even an option for us.
Thanks very much
PG
January 5, 2011 at 7:20 am
No, it's no possible. You can tell what tables the data was discarded from, but not what data was lost. To do that, you'll need a clean backup from before the corruption occurred to compare to. But then if you had a clean backup you could have just restored that and not repaired.
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
January 5, 2011 at 7:23 am
Take each of the errors like
Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10088548), slot 0, text ID 312662884352 is not referenced.
And use DBCC PAGE to do a dump of that page. E.g.
DBCC TRACEON (3604)
go
DBCC PAGE (yourdb, 1, 10088548, 3)
go
Variety of things that could have caused this, including SQL bugs. Unreferenced pages are usually orphans, but it's very hard to determine whether the data wasn't cleaned up properly during a delete, or whether some corruption has occured. I'd need a few hours poking around on the system so I'd say you're not going to find out.
If you don't have any backups to restore from, you have no option but to run REPAIR, or live with the corruption in the database and it's possible effect on SharePoint. No way to tell what effect it will have without examining the database.
Hope this helps.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
January 6, 2011 at 4:03 am
Paul/Gail, thanks very much for both replies - very helpful.
I should've mentioned that we do already know the cause of the corruption, which was a failure of a SAN controller. Unfortunately, by the time the failure was identified and a DBCC CHECKDB was run, nearly a week had passed, by which time the opportunity to restore from a clean backup had passed. We do have a Monthly backup from before the corruption occurred, but restoring this backup will result in a lot of data not being restored.
Running DBCC PAGE as suggested allows me to identify some of the leaves that will be affected, which will help us to identify and restore any SharePoint docs that get deleted by the repair process. However, I think we'll have to accept that other data may also be deleted, which we'll not be able to identify.
Either way, it looks like we really don't have any option other than to run the repair and live with any consequences.
January 6, 2011 at 4:21 am
Do note there's damage to the Sites table as well. So this may be more than just some missing documents. Take a backup before you start, test that the backup is restorable before you start, just in case...
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
January 6, 2011 at 4:43 am
Will do - thanks Gail.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply