I am a bit confused
with the first_lsn, last_lsn, differential_base_lsn in the msdb.dbo.backupset.I have
a sql server 2005 database in full recovery mode. My backup jobs are – nightly full backup, dfifferential backup every six hrs and log backups every hr. In addition to that I do do adhoc backups with copy_only.
Usually full bcakup takes 15 minutes, differential backup 5 minutes and
log backup under one minute.
Because they are scheduled to run on top of the hour, it is quite possible all three jobs are triggered at the same time. ( Full backups do not
block log backups, Not sure if same is tru with diff backups and log backup). In such a situation I want to see a complete sequence of backups what should be the ordering criteria?
I am using below query to get the backup sequence.
Should I order based on backup_start_date, F.family_sequence
View Complete Post