Checking Database Integrity

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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!

  • 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

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

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply