This might be one solution:
select
top 1 bs.backup_finish_date, bs.database_name, bs.server_name, bmf.physical_device_name
from
msdb.dbo.backupset bs
inner
join msdb.dbo.backupmediafamily bmf on bs.media_set_id = bmf.media_set_id
where
bs.database_name = 'yourdbname' and bs.type = 'D' --'L' for log backups
order
by bs.backup_finish_date desc