Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sharepoint database 'docs' corruption ... what if? Expand / Collapse
Author
Message
Posted Wednesday, May 15, 2013 9:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, May 9, 2014 2:18 PM
Points: 341, Visits: 925
Long story short :D

We inherited a sharepoint database on SQL2k with corruption dating back 2 years (so no usable backups). Corruption is affecting only 1 document stored in the docs table (99% sure - from the checkdb results it looks like one of the pages storing this document is damaged, opening the document from Sharepoint fails and gives a a corresponding 823 error in the log)

DBCC CheckDB says that repair_allow_data_loss is the minumum repair option

However - what would happen if the document was just deleted from Sharepoint? It sounds plausible, but I'm assuming that there is more to it than that :D
Post #1453203
Posted Wednesday, May 15, 2013 11:59 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 42,460, Visits: 35,520
The delete would probably fail.

Please run the following and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS




Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1453246
Posted Thursday, May 16, 2013 2:19 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, May 9, 2014 2:18 PM
Points: 341, Visits: 925
The xxxs held the details of the file that was identified

Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136: Errors found in text ID 412871884800 owned by data record identified by RID = (1:14232938:0) SiteId = xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxxxxx and DirName = 'xxxx/xxxx/xxxxx/xxxxxx/xxxxxxx' and LeafName = 'xxxxxxxxxxxx'
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 255: Page (1:5051560) 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:5051560). 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:5051560), slot 0, text ID 412871884800 is referenced by page (1:5051497), slot 0, but was not seen in the scan.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'Docs' (object ID 1993058136).
CHECKDB found 0 allocation errors and 4 consistency errors in database 'databasename'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (databasename).

Post #1453362
Posted Thursday, May 16, 2013 2:46 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 42,460, Visits: 35,520
In that case, since it's a single text page, deleting the doc may remove the corruption (or may not). CheckDB with repair will just remove that one document


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1453371
Posted Thursday, May 16, 2013 3:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, May 9, 2014 2:18 PM
Points: 341, Visits: 925
Excellent thanks, we'll try a deletion & if it doesn't work, a repair
Post #1453393
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse