Wrong transaction log backup files are linking to Full or Differential backup files when using Intellirestore.
For example:
The backups are scheduled for:
Full - Sunday, 12:00 am finishing in 4 hours
Differential - Monday, Tuesday, Wednesday, Thursday, Friday, Saturday 12:00 am finishing in 1 hour
Transaction Log - Every half hour, finishing in 5 minutes
The Differential begins on Tuesday at 12:00 and finishes at 1:00.
The Transaction Logs that begin on Tuesday, at 12:00, 12:30 and finish 12:05, 12:35 (respectively), belong to the Differential from Monday because it contains the transactions that are posting to the database while the Differential is writing . LiteSpeed Intellirestore links the Translog backup files to the Tuesday Differential due to the start time.
Software Defect in Intellirestore. Intellirestore selects the start times of the backup for sequencing, when there may be overlaps in the times that backups run, while transactions are being written to subsequent backup files.
WORKAROUND 1: Deselect Intellirestore check box and select the files manually, however in the example above, there could be multiple transaction log files that belong with Monday (from 12;30, 1:00, etc. depending on the time for the Diff to finish).
WORKAROUND 2: Determine start/end times and LSN #s for correct sequence, by querying the msdb tables.
use msdb
SELECT DISTINCT TOP 20
s1.type,
s1.backup_start_date,
s1.first_lsn,
s1.last_lsn,s1.checkpoint_lsn,
s1.database_backup_lsn
from msdb..backupset s1 inner join msdb..backupmediafamily s2
on s1.media_set_id = s2.media_set_id
where s1.database_name ='Northwind'
and s1.backup_start_date >= '5/30/2008 04:41:25 AM'
and s1.type in('D','L','I')
-- sl.type in ('D','L') means full or Transaction Log backups (if 'I', Differential backups) or ('F' for File Group, 'G' for File Group Differential)
order by s1.backup_start_date desc
