Forum Discussion

toukui's avatar
toukui
Copper Contributor
Apr 22, 2021

How to query the content of LDF file in SQL Server

How to query the content of LDF file in SQL Server though sql sentence
olafhelper's avatar
olafhelper
Bronze Contributor
Apr 23, 2021

Hello,

 

There is no supported way to read the content of the log file (LDF), that's omething completley internal.

 

But there is the unsupported function fn_dbog:

 

SELECT COUNT(*) FROM fn_dblog(null,null)

 

  • toukui's avatar
    toukui
    Copper Contributor
    Apr 23, 2021

    thanks,guys.But is the result of this SQL query the whole content of the log?olafhelper 

Resources