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!