February 2, 2011 at 12:33 pm
When i run one of my day backups , have it do a Database Integrity beforhand. but I keep running into this error
Check Database integrity on Local server connection
Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
Databases: All user databases
Task start: 2011-02-02T00:00:03.
Task end: 2011-02-02T00:00:14.
Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'SharePoint_AdminContent_eae1e7ea-aaec-4469-bf35-750365eee65c', NOINDEX)
" failed with the following error: "Object ID 277576027, index ID 1, partition ID 72057595863105536, alloc unit ID 72057594043826176 (type LOB data): Page (1:4401) could not be processed. See other errors for details.
Table error: Object ID 277576027, index ID 1, partition ID 72057595863105536, alloc unit ID 72057594043826176 (type LOB data), page (1:4401). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Table error: Object ID 277576027, index ID 1, partition ID 72057595863105536, alloc unit ID 72057594043826176 (type LOB data). The off-row data node at page (1:4401), slot 0, text ID 692387840 is referenced by page (1:4405), slot 0, but was not seen in the scan.
Object ID 277576027, index ID 1, partition ID 72057595863105536, alloc unit ID 72057595920252928 (type In-row data): Errors found in off-row data with ID 692387840 owned by data record identified by RID = (1:612:70)
DBCC results for 'SharePoint_AdminContent_eae1e7ea-aaec-4469-bf35-750365eee65c'.
What can I do to fix this error? I'm new to SQL so im just a noob......
If any one can help me in this matter
Please and thank you for all you help.
February 2, 2011 at 1:57 pm
You have a damaged page in your sharepoint content database. It's the integrity check that's failing here, not the backup.
I don't suppose you have a backup from before this started? How long's it been happening?
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 3, 2011 at 10:43 am
Looking at the logs, this has been going on scene Jan 22 2011 . I just took over the old Admin's job as the new IT because he quit. I found this error when I was reviewing the server logs.. I'm very new to SharePoint. So if it's an error on the page. how do I find this page to fix this error? We have many DB'S in SharePoint!
February 3, 2011 at 11:24 am
You don't need to find the page, and there isn't a manual fix.
With sharepoint it's usually better to restore from backup rather than repair. Repair's going to lose data and since everything (site structure included) is inthe sharepoint database, it could cause major problems later on.
I don't suppose restore to 22 Jan is an option? Do you have transaction log backups?
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
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply