• mlsrinivas (12/22/2010)


    I want to re-run the process with your guidance with the mdf and ldf files I got from the data recovery team. I still have the copy of the mdf and ldf files (corrupted) that were recovered from the damaged hard disk.

    Honestly, I wouldn't bother. What you did is the last resort for recovering damaged databases, if it required that, there is no fixing without the data loss.

    Actually now the system is running on the back up data only, that is about 3 months old. I also looking for an option if there is any to update the old database with the new transactions from this damaged ldf file.

    There are log reader tools you can buy, they're around $1000 per licence. Whether they can recover from just a log file that's not attached, I don't know. Pull one of the demos down and see.

    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