Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have done an incorrect update and hence I restored the DB with a backup from the previous day. I have not taken a copy of the corrupted data before restoring the backup. Is there any possibility to get back the data lost between the creation of back up file and restoring the file?

Thanks for saving my job

share|improve this question
    
is the database in full recovery mode? Are the transaction logs available? –  KookieMonster Apr 25 '13 at 8:41
    
The DB is in full recovery mode. Transaction Logs are not enabled –  vasanth Apr 25 '13 at 8:48
    
The full recovery mode requires logs backups: msdn.microsoft.com/en-us/library/ms189275.aspx –  KookieMonster Apr 25 '13 at 9:05

1 Answer 1

If you did not take a log backup between the full yesterday and your restore today, then no, everything changed since yesterday is gone.

In a best case "accidently deleted data" scenario, the process is to take a log backup to capture the "tail"of the log, restore a full backup of the DB to an alternate location, restore log backups using STOPAT to get to the point right before the accidental delete and copy the data.

If you don't have the room to restore an extra copy, or the accidental deletion is severe enough that you must restore over the existing database, then it is twice as important to backup up the tail of the log.

share|improve this answer
    
Going from OP's comment "Transaction Logs are not enabled" I'd say the tail of the log becomes a huge t-log backup. Hopefully he has full backups to start on. –  Marian Jun 19 '13 at 8:51

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.