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