SELECT b.backup_finish_date,a.physical_device_name FROM dbo.backupmediafamily a INNER JOIN dbo.backupset b ON a.media_set_id=b.media_set_id ORDER BY 1;
SQL Server查询备份日期和备份设备名
原文：http://blog.51cto.com/ultrasql/2070108
