Sometimes after taking a backup, one can forget the path where the backup was taken.
The simple script below provides the list of backups taken on the server, backup type ( log - l, Full -D..),backup start date and time, lsn numbers and the path of the backup. Simple and handy.
WHERE backupset.media_set_id = backupmediafamily.media_set_id
ORDER BY backup_start_date DESC