Post reply

DBCC Transaction Logs - How to read/interpret

  • March 1, 2012 at 7:11 pm

    #251646

    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!

  • March 2, 2012 at 7:09 am

    #1454147

    This article may help you digout.

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

  • March 2, 2012 at 7:17 am

    #1454152

    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

  • March 4, 2012 at 6:03 pm

    #1454614

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

  • March 5, 2012 at 3:21 am

    #1454705

    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

  • March 5, 2012 at 6:31 am

    #1454759

    I see...thanks for all who replied 🙂

  • March 5, 2012 at 8:32 am

    #1454823

    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

  • March 5, 2012 at 8:37 am

    #1454826

    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

  • March 5, 2012 at 8:44 am

    #1454834

    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

  • April 21, 2016 at 12:35 am

    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