Search code examples
sqlsql-server-2008logfiles

Read the log file (*.LDF) in SQL Server 2008

I'm searching for a way to read the SQL Server 2008 log file, not to show the information, but to read the meaning of the symbols and the structure of the LOG table. I'm using DBCC LOG('my_table', 3).

Solution

  • See my answer in this Stack Overflow post: How can I view SQL Server 2005 Transaction log file

    Or

    Use this command:

    Select * from ::fn_dblog(null,null)

    And for more information, see How Do You Decode A Simple Entry in the Transaction Log.