SQL Server Forums - how to read Mssql transaction log file

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

Old Forums

CLOSED - General SQL Server

how to read Mssql transaction log file

Forum Locked

Printer Friendly

Author

Topic

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 12/12/2005 : 07:21:18

NIleema writes "how to read Mssql transaction log file"

robvolk
Most Valuable Yak

USA
15557 Posts

Posted - 12/12/2005 : 07:22:26

Get Log Explorer from Lumigent:

http://www.lumigent.com/products/le_sql.html

Red Gate also has a log reading product:

http://www.red-gate.com/products/SQL_Log_Rescue/index.htm

There's also the DBCC LOG command. It is undocumented though, and the output is not easily readable. Log Explorer would be your best bet.

Kristen
Test

United Kingdom
22191 Posts

Posted - 12/12/2005 : 14:22:11

Hi NIleema, Welcome to SQL Team!

If might help us to know why you are needing to do this?

Kristen

activecrypt
Posting Yak Master

Germany
165 Posts

Posted - 12/13/2005 : 00:47:51

Hi,
dbcc log(yrdb)
or you can use some Third Party tools as suggested , but curious to know why you wants to read this logs ! do plan to undo some actions !

:-)
Regards

Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com

TRACEYSQL
Aged Yak Warrior

576 Posts

Posted - 08/26/2006 : 08:16:23

hi there when u say read log files and the tools mentioned is this reading the LDF files...

robvolk
Most Valuable Yak

USA
15557 Posts

Posted - 08/28/2006 : 10:21:15

Yes.

Topic

Forum Locked

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.