1

Is there a free tool to read .ldf (Sql server database transaction log files) files ?

Thanks in advance,

Albert

Improve this question
1

I know of a couple of options, unfortunately I don't know of any free ones, but many offer free trials if your just looking to do something as a one off:

Improve this answer
1

There's an undocumented command which allows you to query a transaction log.

http://killspid.blogspot.com/2006/07/using-fndblog.html

Improve this answer
1

Have a look at SQL Log Rescue http://www.red-gate.com/products/SQL_Log_Rescue/index.htm

Improve this answer
1
  • Just bear in mind this is only for SQL 2000 – Sam Cogan Nov 9 '09 at 15:03
0

What exactly are you trying to achieve?

There are undocumented command such as fn_dblog() and DBCC LOG that will give you a dump of SQL Server log transactions, although don't expect to see nicely formatted DDL/DML.

There are products (not free) which can be used to reconstruct the log output into T-SQL. They are:

  • ApexSQL Log
  • SQL Log Rescue
  • Log Explorer
Improve this answer
0

Try Free SQL LDF File Viewer which allow you to read and analyze SQL Server Transaction logs.

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.