Post reply

How to Repair WSS_Content Database in Sql Server 2008 ?

  • March 27, 2015 at 5:27 am

    #295490

    Hi,

    We have sharepoint foundation 2010 and we were getting error on backup so we did run DBCC CHECKDB and found some error. I am also attaching file. Look like i found 0 allocation errors and 55 consistency errors in database 'WSS_Content'.

    Now i am not sure what i need to do to repair. How do i repair ? Any Drawback ? How long it's going to take it ? My Sharepoint will be down ?

    Please Help Me.

    Thank You !!

  • March 27, 2015 at 2:47 pm

    #1787037

    You can use SQL Server Repair Kit. A convenient, reliable and ultimately efficient MS SQL database repair tool for system administrators, developers and database experts. Best in class performance and outstanding usability for users with and without experience.

    For more: http://www.mssqlserver.repair/[/url]

  • March 30, 2015 at 2:33 am

    This was removed by the editor as SPAM

  • March 30, 2015 at 2:59 am

    #1787238

    I'd recommend restoring from a clean backup.

    Since Sharepoint keeps the site structure as data, any repairs may leave the site unusable. Rather restore from a backup which was taken before the corruption occurred.

    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

  • March 30, 2015 at 10:53 pm

    This was removed by the editor as SPAM

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

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