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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We've had some data loss and don't have a reliable backup it seems. We do have HUGE transaction logs and there was some thought that we might be able to use these to get back to a certain point.

Is it possible to help rebuild a database using transaction logs?

SQL Server 2008 R2, btw.

(x-posted from stackoverflow)

share|improve this question
up vote 6 down vote accepted

No. You need a previous image of the a database (ie. a reliable backup) to start from.

share|improve this answer
It looks like we found a .bak file from July. Not ideal, but it's something. – spuppett Oct 28 '11 at 16:12
Thanks for your input. – spuppett Oct 28 '11 at 19:48

As Remus Rusanu said, you cannot rebuild the database. It's bad, but it's true. But the data from your log can be extracted by tools like Lumigent LogExplorer. I understand, that it is very litle possiblity that it can help, but maybe this is the way to extract something that you need.

share|improve this answer
+1 There are some incredible tales of recovery from impossible situations. A percentage of the data may indeed be recoverable, if it has sufficient value to warrant the effort to recover. – Mark Storey-Smith Oct 28 '11 at 21:30

Your Answer


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.