How to recreate sql from read transaction logs

Question

How to read the transaction log to re-create an insert statement

Answer 1

A very old story from the days of SQL 2000: Someone spent about a year to study the format of the transaction log and this person was able to produce a tool that was able to read the transaction log and give you the statements. This tool was commercially available for a while, and gained some popularity. However, I was not in business for a very long time. Microsoft change the log format in SQL 2005, so the tool was no longer functional. And they have probably made more changes since then.

Answer 2

The transaction log is a log of changed disk pages, so if you study the format and did comparisons you could tell committed vs noncommitted row changes, but this would only tell you the effects of the sql statements, not the statement itself. You could not even tell how many transactions made the changes.

Answer 3

Hey, I also been in this situation please refer the below link, that is open source also easy to customize.

https://github.com/ap0405140/MSSQLLogAnalyzer