Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Recently, one of my customers had a server crash. Unfortunately, the 3th party who was responsible for the backup had 'forgotten' to schedule a backup of the DB (I know, I should have noticed that).

After a professional recovery, I have the mdb and the ldf back. I could attach them back in SQL Server 2005 Express. On first view, everything looked OK.

However, the most recent changes (say from one month before crash) are missing. Has anyone seen that before? Does anyone know a solution for that? Is it possible that it is still in the ldf? I think the recovery model was Simple. As a side note, I'm sure that the data was there since there is a printed version. I'm also sure that it is the most recent mdb and ldf that was recovered and sent.

I already did several DBCC checkDBs with different parameters (every time on a fresh mdb/lfd combination, of course). I know there is a consistency error somewhere but it doesn't block me to query the last 20000 rows. So I expect to find the last records there (or am I wrong here?). The fix for this consistency error is of lower priority since it occurs in the older data region. Worst case scenario, we can remove that part.

So, please help me with the missing data.

Thanks in advance!

share|improve this question
add comment

1 Answer 1

I hate to bear bad news, but if the recovery mode was SIMPLE, the portion of the log that contained the "lost" transactions was marked for reuse as soon as the transaction was committed. So the missing transaction won't be recoverable from the .ldf file.

SIMPLE recovery does not allow for point-in-time recoveries, it only permits recovery at the point of a full backup.

share|improve this answer
    
That make sence. If I understand well, all data since my last manual backup is not commited to the mdf and is lost. Even if I have the ldf available. I thought, there was a periodical procedure (checkpoint) that commits the data in de mdf. My lesson: set all databases in full recovery mode (and take care of backup myself) –  bvbiz Mar 29 '13 at 8:30
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.