how to read Mssql transaction log file

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

how to read Mssql transaction log file

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

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

NIleema writes "how to read Mssql transaction log file"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-12-12 : 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

22859 Posts

Posted - 2005-12-12 : 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

165 Posts

Posted - 2005-12-13 : 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

594 Posts

Posted - 2006-08-26 : 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

15732 Posts

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

Yes.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources