patternMinor
Can I use transaction logs to rebuild a database?
Viewed 0 times
canlogsrebuilddatabasetransactionuse
Problem
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)
Is it possible to help rebuild a database using transaction logs?
SQL Server 2008 R2, btw.
(x-posted from stackoverflow)
Solution
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.
Context
StackExchange Database Administrators Q#7359, answer score: 6
Revisions (0)
No revisions yet.