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


SELECTb.backup_finish_date,a.physical_device_nameFROMdbo.backupmediafamilyaINNERJOINdbo.backupsetbONa.media_set_id=b.media_set_idORDERBY1;