SQL Recovery from MDF and LDF – Missing Data

5 pts.
Tags:
LDF
MDF
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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:
    report
  • 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:
    report
  • 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:
    report

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following