Missing last 2 Days records ..How can i recover ..

Question

Post reply

Missing last 2 Days records ..How can i recover ..

John Paul-702936

SSCrazy

Points: 2182
More actions
April 14, 2010 at 10:08 am

#213802

Hi ..
Missing last 2 Days records ..How can i recover ... We don't have any differtial backUp. The Last Full backUp taken was 3 days ago..
But the LDF is upto date (modified Date )..
Is there a Chance to recover the missing data ...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442467

April 14, 2010 at 10:19 am

#1151517

What recovery model is the database using?

John Paul-702936 SSCrazy Points: 2182 More actions · Answer 2

John Paul-702936

SSCrazy

Points: 2182

April 14, 2010 at 11:09 am

#1151564

SIMPLE

Lowell SSC Guru Points: 323518 More actions · Answer 3

John Paul-702936 (4/14/2010)
SIMPLE

ouch.

assuming deletion of specific data, then the data is lost. there is no way to recover deleted data when in SIMPLE mode;

the typical thing you'd have to do restore a previous backup as a new name, and compare , say a specific table in the current database to the newly restored database;

then you'd need to identify the desired changes and script them out to insert/update the incorrect data in the current db.

by "losing" two days of data, do you mean one specific table? how do you know the data is missing? did someone restore a database over the top of existing, or delete something?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

John Paul-702936 SSCrazy Points: 2182 More actions · Answer 4

yeah ...Missing Data mean i found like ..

User runs the reports (web based ) ..daily .. They are unable to find the records of last 2 days ..

When i run the profiler against the server .. there is table called dbo.History..

When i executed the Script like Max(date).. which i got is 10 Apr 2010 ..

So . the data is not Up to date ..

The latest backUp was taken on 10 Apr..

only the LDF file shows like modified date as Current Date ..

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Is this an on-line application or is the data loaded via files?

Unfortunately, there is no way to recover your data at this point. Once data has been updated to the database and a checkpoint issued, the log space is available for reuse and the data that would be in the log file can now be overwritten. Here is a good reason for your database to be using the FULL recovery model and taking periodic transaction log backups.

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 6

As already pointed - unfortunately - data is gone.

I would review backup and restore histories to check if eventually somebody took a manual backup after the last scheduled one and, to check if somebody has restored a backup causing data lost.

More important, I'll be setting backup/recovery strategy to full recovery mode and review backup strategy on all other databases in the shop.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.