Each log backup taken after a normal FULL backup has a sequence to this last FULL backup as initial starting point.
Does this mean for the very first log backup after a full backup the Full:last_lsn >= Log:first_lsn
This is an extract for the backupset table: (on closer inspection it seems there are 2 full backups every morning one is_snapshot = true (very small file size) the other false and resembles a normal SQL backup (file size is healthy).
5am DB Backup (is_snapshot) first_lsn = 161382000005802000081 last_lsn = 161382000005812400001
6am DB backup first_lsn =161382000005827200058 last_lsn=161382000005830100001
7am 1st Log backup after full, first_lsn = 161335000002837800001 last_lsn = 161382000005923900001
Does this look ok?
When you create a backup using the COPY_ONLY option, the backup doesn't interrupt the sequence of the LOG backups
How does a full database backup interrupt the sequence? Is the 6am backup in the extract interrupting something?
I think I'm almost getting my head around this...appreciate your help! Thanks