Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

Thanks in advance,

Albert

share|improve this question

4 Answers 4

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:

share|improve this answer

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

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

share|improve this answer

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

share|improve this answer
    
Just bear in mind this is only for SQL 2000 –  Sam Nov 9 '09 at 15:03

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
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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