1

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

Thanks in advance,

Albert

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:

1

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

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

1

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

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
0

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

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