Decompile a T-Log file | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Decompile a T-Log file

Is there any way to find out what commands or instructions are in a tranny log? I have T-Logs for every hours. If something had happened in the middle of an hour, and I want to trace it, is it possible? CanadaDBA
The only practical way to do this is using a third-party tool, such as Log Explorer from or ApexSQL Log from
Brad M. McGehee, MVP
Or, if you have no money to spend, like me,<br />create a userLog table, and log every critical<br />db execution from your program [<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />].<br /><br />-mingus
I believe the database recovery model is set to FULL (as defined in your other post) and in case of any disaster SQL will provide the ability to recover the database to the point of failure or to a specific point in time. To guarantee this degree of recoverability, all operations, including bulk operations such as SELECT INTO, CREATE INDEX, and bulk loading data, are fully logged. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.