Re: Reading Transaction Log Files

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Chris Bilson (cbilson_at_pobox.com)
Date: 08/09/04 

Date: Mon, 09 Aug 2004 05:27:41 -0700

Thanks for answering my question. So apparently, they reverse engineered
transaction logs through blood sweat and tears.

Andrew J. Kelly wrote:
> A couple hundred bucks would be a bargain to do this type of task. These
> companies spent a LOT of time reverse engineering the cryptic entries in the
> logs and providing a gui to easily put all this together. Pretty much
> anyone could accomplish this given enough time. The amount of time you
> would spend or waste would be worth far more than a few hundred dollars and
> would have much less features. If you really have that much time to kill
> you may want to look at these:
>
> http://www.databasejournal.com/features/mssql/article.php/1443371
> http://www.databasejournal.com/features/mssql/article.php/1460161
> http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp
>