SQL Server查询备份日期和备份设备名

查询备份日期和备份设备名，用于检查某日的备份是否执行。

SELECT b.backup_finish_date,a.physical_device_nameFROM dbo.backupmediafamily a INNER JOIN dbo.backupset bON a.media_set_id=b.media_set_idORDER BY 1;