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)


2 Answers 2


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

  • It looks like we found a .bak file from July. Not ideal, but it's something.
    – spuppett
    Oct 28, 2011 at 16:12

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.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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