Software to recover corrupted .bak file

Posted on 2013-10-03
Medium Priority
Last Modified: 2013-10-11
We lost 2 disks in our array and our main content database backup for SharePoint 2010 is corrupt.  Has anyone tried any of the software on the net that says it can recover .bak files?  Does it matter that it's from a SharePoint site because the backend is SQL?  One software comes up in so many different search results that I feel like it's spam and untrustworthy.  So if anyone has any experience or heard good things about a program to recover .bak files please  post!  Thanks!
Question by:HSI_guelph
  • 3
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 39544300
where are these back files stored ? are they in the same SAN ? , you can try recovering the pages from the backup if you have one handy

Author Comment

ID: 39544340
We lost our entire SharePoint site.  The .bak file is almost 3 gigs and it stops during the restore process so we have nothing of our old site.  When we backed up the database there was a corruption and we didn't catch it.  When the array rebuilt itself there were multiple issues and problems so we tried to restore from a backup but the backups are corrupt.  There is supposed to be a command that will have the restore process ignore or skip corrupted parts it finds but we don't know how to do that or what the command is.  My supervisor is the one who is working with the database so I'm trying to support by researching and passing along anything useful that I can find.
LVL 75

Accepted Solution

Anthony Perkins earned 2000 total points
ID: 39548460
There is supposed to be a command that will have the restore process ignore or skip corrupted parts it finds but we don't know how to do that or what the command is.
I suspect you are referring to the RESTORE option CONTINUE_AFTER_ERROR

Author Closing Comment

ID: 39566524
We were able to recover one document, we can't seem to recover the entire thing but pieces like a list or document if we know where it was.  So we have a glimmer of hope.  But something else my supervisor was trying to recover was being difficult, it could be because there are almost 40 versions of the document.  We have someone looking over the document we recovered and hopefully it seems in good shape and we can salvage more data.

Thank you very much for the help!

Author Comment

ID: 39566963
Update:  Very happy to reply that the restore with continue_after_error option has worked and we are recovering data and are very relieved.  Thanks again!

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question