List the backups for a database

select backup_start_date, backup_finish_date, physical_device_name  from backupset bs
inner join backupmediafamily bmf on bs.media_set_id = bmf.media_set_id
where database_name = ''
order by backup_start_date desc