Home > IT Answers > SQL Server > SQL Recovery from MDF and LDF – Missing Data
SixCs
5 pts.
 SQL Recovery from MDF and LDF – Missing Data
LDF, MDF, SQL 2000, SQL Server 2000, SQL Server backup, SQL Server backup and restore
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
ASKED: June 14, 2010  2:10 PM
UPDATED: October 5, 2011  9:26 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  June 15, 2010  3:27 am  by  mshen   27,310 pts.
All Answer Wiki Contributors:  mshen   27,310 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Hayyat
 10 pts.
 

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.

Giacomo11
 10 pts.
 

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.

Sharen123
 20 pts.