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 www.lumigent.com or ApexSQL Log from www.apexsql.com.
—————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>