List of all backups taken after the latest full backup

To find the list of all the backups taken on a database after the latest Full Backup(including), you can use the below query:

declare @DatabaseName varchar(200)
set @DatabaseName = 'DatabaseName';

select backup_set_id,database_name,backup_size,type as BackupType, as BackupName,Backup_Start_Date,Backup_Finish_date,Physical_device_name from msdb.dbo.backupset A INNER JOIN msdb.dbo.backupmediafamily B on A.media_set_id=B.media_set_id where database_name = @DatabaseName and backup_set_id>=(Select max(backup_set_id) from msdb.dbo.backupset where database_name= @DatabaseName and type='D')

This information can be useful when you are trying to figure out which/how many backups you should restore, if you want to bring the database to point in time(remember, you should also take Tail log Backup,if possible) and Also, this query works if you have Full, Differential, Log backup implementation