HOW TO READ .LDF FILES

Answer 1

There is no supported way to do this. There is an undocumented command, fn_dump_dblog() (mentioned in here: http://www.karaszi.com/SQLServer/info_minimizing_data_loss.asp). Use as own risk. There are also 3:Rd party products (I believe) for this.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 2

Hi,

It is possible with the following DBCC command.

DBCC LOG ('<DATABASENAME>')

It will return a table contain current LSN,Operation,Context,Transaction ID,Log Block Generation. In this one with help of Operation column you can find what operation done on LOG file. Only drawback is it will not provide full information.