SQL Recovery from MDF and LDF – Missing Data

5 pts.
Microsoft SQL Server 2000
SQL 2000
SQL Server backup
Where to start ... On 6/2 we lost a major system that we found relies on a database that hasn't been backed up since 5/7. We lost 3 of 4 HDD in a RAID5 array. We sent the drives to a recovery firm and they have recovered all of the data. However, the timestamp on the MDF and LDF files for this database still show 5/7. I am assuming the timestamp may not change if SQL state hadn't been changed (backup/reboot). I did finally get the files mounted and usable. However, it looks like the data is still only from 5/7. The data recovery firm says this should be the latest data. Is it possible there is something in the log files yet after the 5/7 date? This is on a SQL 2000 server. I am an infrastructure/net admin so my SQL knowledge doesn't run exteremly deep. I appreciate any info one may have. Best Regards, Nate

Software/Hardware used:
SQL 2000

Answer Wiki

Thanks. We'll let you know when a new response is added.

Sounds very odd that the data from the recovery firm matches the date of your last backup. Your transaction log and database files should have been modified since then.

Try running a restore. Your database may be in the state of your last backup, and the transaction logs should have all the transactions since your backup. That is unless the database is set to the simple recovery model; if that is the case, you won’t have anything in your transaction logs.

Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Hayyat
    get the <a href="http://www.recoverytoolbox.com/how_to_repair_sql_2005_database_mdf_files.html">sql server repair mdf</a> utility to fix data corruption issues in the files of specified format
    10 pointsBadges:
  • Giacomo11
    For working out such complicated trouble there is a mdf recovery. The utility has clear and intuitive interface. It uses high end methods of restoring sql data. The program can't modify source data during restoring.
    10 pointsBadges:
  • Sharen123
    Recover SQL server MDF file successfully and also restore SQL server corrupted Database with all original information with help of this SQL Server Recovery Software.
    20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: