DBCC Transaction Logs - How to read/interpret

  • Hi Guys,

    How to read/interpret the transaction logs displayed by DBCC command? can I convert the records into human readable format? If so, how?

    Thanks in advance!

  • This article may help you digout.

    http://www.simple-talk.com/community/forums/thread/1439.aspx

  • Klarence A. (3/1/2012)


    Hi Guys,

    How to read/interpret the transaction logs displayed by DBCC command? can I convert the records into human readable format? If so, how?

    Thanks in advance!

    Transaction Log file is for the recovery purpose (crash recovery & rollbacks etc). It is not there so that one can read the data from it.


    Sujeet Singh

  • Thanks for the response but is there a way to view the transaction logs for auditing purposes?

  • Transaction logs are not audit logs, they don't contain a lot of the information that an audit would need (login name, host name, etc). They are there for database integrity and durability, not for audits.

    I would recommend custom audit triggers if you want to audit data changes, or a SQLTrace if you want to audit procedure calls and the like.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I see...thanks for all who replied 🙂

  • Klarence A. (3/1/2012)


    Hi Guys,

    How to read/interpret the transaction logs displayed by DBCC command? can I convert the records into human readable format? If so, how?

    Thanks in advance!

    If you're in some sort of jam and need to query information from the transaction log today, then the SQLskills.com website would provide the most advice about internals. If you're thinking about implementing some solution that involves auditing events, then consider extended events.

    http://sqlskills.com/blogs/jonathan/post/An-XEvent-a-Day-(22-of-31)-e28093-The-Future-e28093-fn_dblog()-No-More-Tracking-Transaction-Log-Activity-in-Denali.aspx

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Eric M Russell (3/5/2012)


    If you're thinking about implementing some solution that involves auditing events, then consider extended events.

    Though since this is the SQL 2000 forum, it needs mentioning that Extended Events are SQL 2008+

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (3/5/2012)


    Eric M Russell (3/5/2012)


    If you're thinking about implementing some solution that involves auditing events, then consider extended events.

    Though since this is the SQL 2000 forum, it needs mentioning that Extended Events are SQL 2008+

    Sorry, you're right that with 2000 the events would have to be captured using SQL Profiler. Perhaps the Transaction event class would be a start.

    http://technet.microsoft.com/en-us/library/aa173880(v=sql.80).aspx

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply