We experienced a failure on one of our MS SQL servers this morning and we are currently investigating the cause. One thing I have noticed is a massive jump in the size of the transaction log backups (.trn). We backup the logs every 15 mins and the average size is around 8Mb. This morning, at the time of the failure, the log file jumped in size to 5.8Gb.
I am assuming if I can read the contents of these TRN files it may give me some clue as to what was going on at the time everything failed.
Is there a way for me to read these files including a timestamp for each record?