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)


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

|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

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.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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