Software to recover corrupted .bak file

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!
HSI_guelphAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:
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
http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/01/18/fixing-damaged-pages-using-page-restore-or-manual-inserts.aspx
0
HSI_guelphAuthor Commented:
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.
0
Anthony PerkinsCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HSI_guelphAuthor Commented:
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!
0
HSI_guelphAuthor Commented:
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!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.