Recent Backup

use msdb
go
select
 mf.media_set_id,
 mf.physical_device_name,
 s.name,
 s.database_name,
 s.backup_start_date,
 s.backup_finish_date,
 s.backup_size, s.type
from
 backupmediafamily mf,
 backupset s
where
 mf.media_set_id = s.media_set_id
order by 
backup_finish_date desc