Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
corrupted database and backup files

Proposed Answer corrupted database and backup files

  • Wednesday, May 04, 2011 11:44 AM
     
     
    Sign In to Vote
    0

    Hello,

    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

    ruediger

     

All Replies

  • Wednesday, May 04, 2011 11:46 AM
     
     
    Sign In to Vote
    0
    Hmmm 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 PM
     
     
    Sign In to Vote
    0
    You 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 AM
     
     
    Sign In to Vote
    0
    Yes, 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
     
     
    Sign In to Vote
    0

    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
     
     Proposed Answer
    Sign In to Vote
    2

    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. 

    SQL Database Recovery Blog

    SQL Backup Database Recover Blog

    • Proposed As Answer by Jack Rider Tuesday, May 29, 2012 7:33 AM
    •