Wednesday, May 04, 2011 11:44 AM
we had harddisk crash on our raid. We could recover the Files, but now die MDF- und LDF-Files ar corrupted and we cannot attach them to a SQL-Server. Also we have backup-files of the databases and transactionlog but this files also corrupted.
Have anybody an idear how I can get I get recover Data from this files? Is there a tool which I can open the backup of the transaction log or the mdf-files?
Thanks for help
Wednesday, May 04, 2011 11:46 AMHmmm try running restore with CONTINUE_AFTER_ERROR clause... But your situation does not look good...
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Wednesday, May 04, 2011 4:38 PMYou should also verify that at the moment the disks are not corrupted, the reason to suspect so is because also the backup files I believe taken before the crash are bad.
-- Yaniv www.sqlserverutilities.com http://blogs.microsoft.co.il/blogs/yaniv_etrogi
Wednesday, May 25, 2011 5:31 AMYes, there are so many tools available in the market that repair and restore your corrupted data from the mdf file. I have googled for you and found www.stellarsqldatabaserecovery.com . It provides an advanced tool that repair corrupt mdf as well ndf file of sql server and compatible with MS SQL 2000, 2005, 2008 & 7.0. You can see the preview of your corrupt database before download the full version.
Read my blog (Blog)
Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you
Thursday, May 03, 2012 1:48 PM
As mentioned above that the best way forward is to restore last known good backup.
If your business doesn't allow to loose data post-backup till date then you can choose to approach data recovery companies in your location.
Tuesday, May 29, 2012 7:33 AM
Its like the same problem I experienced sometimes ago and when I googled it, I found there is availability of large number of tools available in market for recovering corrupt database and backup files but fortunately I got some links of blog and I am telling you it was very helpful. It helped in viewing the repaired database with its free version and proved its reliability after which I got the access for complete functional tool.
- Proposed As Answer by Jack Rider Tuesday, May 29, 2012 7:33 AM