Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Read TRN Data Expand / Collapse
Posted Tuesday, October 16, 2012 1:09 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 28, 2015 12:01 AM
Points: 56, Visits: 157
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.


- Peter
Post #1373056
Posted Friday, November 16, 2012 4:47 PM



Group: General Forum Members
Last Login: Thursday, August 21, 2014 9:06 AM
Points: 162, Visits: 367
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.

Post #1385883
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse