Transaction Log

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Transaction Log

Transaction Log

Rate Topic

Display Mode

Topic Options

Author

Message

Won Byon

Posted Wednesday, September 15, 2010 4:04 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 17, 2012 3:11 PM
Points: 5, Visits: 78

Anyone know if it's possible to query the transaction log or transaction log backup file to find the actual text of commands being executed? I know Lumigent's "Log Explorer" product used to allow this on sql 2000, and when I called them, they mentioned that it's going to be re-released soon. Also, I've tried using ApexSQL's Log product w/o any success.

I know how to restore to a given point in time, but if I'm trying to troubleshoot a certain type of occurrence, what I'm trying to avoid is running Profiler, and then waiting for the occurrence. I've used triggers to copy to logging tables, but like Profiler, if the problem doesn't surface for several days at a time, and the transaction volume is fairly heavy, it's time consuming to set this up, maintain, and monitor, so that's why I was looking for a way to inspect/query the transaction log directly.

Thanks in advance,

WB

Post #986762

SQLRNNR

Posted Wednesday, September 15, 2010 4:44 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 2:37 PM
Points: 18,853, Visits: 12,437

This may be of some help
http://www.quest.kr/change-director-for-sql-server/demo/chap06.htm

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #986786

Won Byon

Posted Thursday, September 16, 2010 11:12 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 17, 2012 3:11 PM
Points: 5, Visits: 78

Thanks Jason. I tried the link, and can see the demo, but can't use the links to get to the trial download (just shows a blank screen). I tried to find the same product on the US version of their site, and I think it's in the "Toad for SQL Server" product's "transaction log recovery" part. Do you know if this is the same product? It's odd that the Korean site / .kr shows different product names.

WB

Post #987891

SQLRNNR

Posted Thursday, September 16, 2010 11:45 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 2:37 PM
Points: 18,853, Visits: 12,437

That's probably the tool.

And yes it is odd for the sites to have different names for the tools.

Post #987898

Won Byon

Posted Monday, September 20, 2010 4:41 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 17, 2012 3:11 PM
Points: 5, Visits: 78

Thanks Jason.

Post #989834

SQLRNNR

Posted Monday, September 20, 2010 5:26 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 2:37 PM
Points: 18,853, Visits: 12,437

You're welcome.

Post #989851

« Prev Topic | Next Topic »

Permissions