I am studying differential backups. I know that I can create a differential backup which will contain all the modified data from last full backup.
I wonder isn't it possible to create a backup from the last differential backup?
I mean to create a base full backup, then differential backup1, which contains all the data modified from full backup, then create backup2 which contains modified data from backup1, not full backup.
If it is possible how can I do it? Also can I do the same only with Log file backups?
Thanks for your time.
Best Answer
SQL Server differential backups capture all of the LSNs from the last full backup in the backup chain. Log backups capture all of the LSNs from the last log backup. If there has not been a log backup since taking the full backup, the log backup captures the LSNs from that one. Considering this, the log backups better relate to "incremental".