March 1, 2012 at 7:11 pm
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
This article may help you digout.
http://www.simple-talk.com/community/forums/thread/1439.aspx
March 2, 2012 at 7:17 am
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.
March 4, 2012 at 6:03 pm
Thanks for the response but is there a way to view the transaction logs for auditing purposes?
March 5, 2012 at 3:21 am
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
March 5, 2012 at 6:31 am
I see...thanks for all who replied 🙂
March 5, 2012 at 8:32 am
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.
"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
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
March 5, 2012 at 8:44 am
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