Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

Thanks in advance,

Albert

share|improve this question

closed as off-topic by EEAA Apr 28 at 15:03

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

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

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

share|improve this answer

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