I have a database that automatically takes full backup weekly, differential backup daily, and transaction log backup every 5 minutes. The full backup takes about half an hour so its runtime often overlaps with the differential backup and any transaction log backups happens during.
What happens to the data modified during each types of backup? Would they be included in the backup or the backup contains only data up to the point of BackupStartDate or other attributes in the backup? I want to be able to calculate when trying to restore to a point of time.
If the Diff backup occurs after a full backup process has started and finishes after the full backup has finished, would it base on the last full backup or this one?
I haven't found a authoratative explanation on the web. Appreciate if anyone can point me to the right direction.
