Read TRN Data

• Peter2012

  SSCommitted

  Points: 1652

  More actions

  October 16, 2012 at 1:09 am

  #263297

  Hi Gurus,

  We've configured MS SQL Server 2008 R2 and restored the recent backup of PRD database (.bak file) into our DR server, for instance: PRD DB backup of 14 Oct 2012.

  There are some transaction log files (*.TRN) that we'd like to read and find out information related to LSN (first LSN, last LSN, Checkpoing LSN, DatabaseBackup LSN, etc).

  We know that it can be done by using this command:

  RESTORE HEADERONLY FROM DISK='d:\Temp\WIR_20121014210000.trn'

  However, this only read 1 TRN file, is it possible to use SQL query to ready a bunch on TRN files and generate an output containing LSN related information?

  Appreciate for your help.

  Thanks.

  - Peter

• KylesWay

  Old Hand

  Points: 369

  More actions

  November 16, 2012 at 4:47 pm

  #1559958

  I've found this article helpful.

  I hope this helps.

  Also keep in mind that you can save this data to a table and start slicing and dicing from there. 🙂