Read previous days transaction log .trn

• Bruin

  SSCrazy

  Points: 2058

  More actions

  February 28, 2022 at 6:01 pm

  #3990633

  Is there a utility or script that I can see the Transactions that happened in a Trn log backup file (.trn). I would like to see what transactions and tables where updated in the Backup log.

  Thanks.

• Michael L John

  One Orange Chip

  Points: 27055

  More actions

  February 28, 2022 at 6:18 pm

  #3990643

  fn_dump_dblog

  This link may get you started.  https://www.mssqltips.com/sqlservertip/3555/read-sql-server-transaction-log-backups-to-find-when-transactions-occurred/

  However, it seems like setting up an extended event to capture what you need, and reading that, may be a better option.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/