Backup & Recovery from First Principles, Part 3: The Log Chain and How People Break It

showed that log backups form a linked list: each backup’s first_lsn equals the previous backup’s last_lsn. Point-in-time restore works by walking that list. Break one link and every log backup after the break is useless…