It is happening on the two main databases at the same time, the 11pm transaction log backup (named *120000.trn in the GMT naming scheme).

I cannot find another job (apart from...

Adding the JOIN produced 0 results. That means only 1 backup is in each file? which is what it should be.

The filenames are being constructed by the log...

and:

59872015-10-11 12:30:00.0002015-10-11 12:30:00.000L349184NULLNATOFFICE\SqlService175368500000019499000011753685000000194990000117536850000001945100037NULL12D:\RELIVE_LogShipping\TWS_RE7_Live_20151011013000.trn

59852015-10-11 12:15:00.0002015-10-11 12:15:00.000L349184NULLNATOFFICE\SqlService175368500000019499000011753685000000194990000117536850000001945100037NULL12D:\RELIVE_LogShipping\TWS_RE7_Live_20151011011500.trn

59832015-10-11 12:00:00.0002015-10-11 12:00:00.000L349184NULLNATOFFICE\SqlService175368500000019499000011753685000000194990000117536850000001945100037NULL12D:\RELIVE_LogShipping\TWS_RE7_Live_20151011010000.trn

59812015-10-11 11:45:00.0002015-10-11 11:45:00.000L349184NULLNATOFFICE\SqlService175368500000019499000011753685000000194990000117536850000001945100037NULL12D:\RELIVE_LogShipping\TWS_RE7_Live_20151011004500.trn

since this is happening on 2 databases; both fail to restore at the same transaction log restore point in time.

Results of the posted SQL are:

backup_set_idbackup_start_datebackup_finish_datetypebackup_sizenameuser_namefirst_lsnlast_lsndatabase_backup_lsndescriptionfamily_sequence_numberdevice_typephysical_device_name

59862015-10-11 12:30:00.0002015-10-11 12:30:00.000L98304NULLNATOFFICE\SqlService587700000030840000015877000000308400000158770000002957000037NULL12D:\RELIVE_LogShipping\TWS_RE7_Inhouse_Tables_Live_20151011013000.trn

59842015-10-11 12:15:00.0002015-10-11 12:15:00.000L98304NULLNATOFFICE\SqlService587700000030840000015877000000308400000158770000002957000037NULL12D:\RELIVE_LogShipping\TWS_RE7_Inhouse_Tables_Live_20151011011500.trn

59822015-10-11 12:00:00.0002015-10-11 12:00:00.000L98304NULLNATOFFICE\SqlService587700000030840000015877000000308400000158770000002957000037NULL12D:\RELIVE_LogShipping\TWS_RE7_Inhouse_Tables_Live_20151011010000.trn

59802015-10-11 11:45:00.0002015-10-11 11:45:00.000L98304NULLNATOFFICE\SqlService587700000030840000015877000000308400000158770000002957000037NULL12D:\RELIVE_LogShipping\TWS_RE7_Inhouse_Tables_Live_20151011004500.trn

The backups are occurring every 15 minutes but note that the last two listed have a gap in the LSNs even though they are consecutive backups.

Actually SQL Server is being changed iteratively, it is not evolving. It is being directed to a goal by intelligence.

You are totally correct that management don't want to hear. Yes I suspect they think they are the only ones with ideas that can make a difference.

I have been sidelined and unable to reenter the market. I am 51.

It doesn't help that I think .net is the wrong direction, it takes a lot of code...