Here’s a nice page with some code which shows how to build a database test case sample where you can run your own tests.
How do I map a differential/transaction log backup to its full backup without using MSDB?
If you have multiple full, differential and transaction log backups, there are chances you may end up facing the error below during the restore process. âThis differential backup cannot be restored because the database has not been restored to the correct earlier stateâ You know that any differential/T-log backup is mapped to particular full…
I like this site’s simple list of rules which shows the FULL backup and where the CheckpointLSN and FirstLSN could be found in the DIFF and LOG backups.
Considering SQL Server Log Sequence Numbers for Backups
Take a look at this blog and understand SQL Server log sequence numbers for backups and know why LSN is important while restoring the database
Source: www.sqlmvp.org/sql-server-log-sequence-numbers-for-backups/
This page has nice graphics following the LSNs.
Understanding SQL Server Log Sequence Numbers for Backups
This tip describes SQL Server Log Sequence Numbers (LSNs) and how the sequence numbers link full, differential and transaction log backups. We will look at sample backups and how these LSN values can be read from the backup files to determine the restore
Source: www.mssqltips.com/sqlservertip/3209/understanding-sql-server-log-sequence-numbers-for-backups/