--====================================================
--查看数据库备份的详细信息:时间存储地址最大/最小LSN
SELECT * FROM msdb.dbo.backupset AS BS
INNER JOIN msdb.dbo.backupfile AS BF
ON BF.backup_set_id=BS.backup_set_id
INNER JOIN msdb.dbo.backupmediaset AS BMS
ON BMS.media_set_id=BS.media_set_id
INNER JOIN msdb.dbo.backupmediafamily AS BMF
ON BMF.media_set_id=BMS.media_set_id
ORDER BY BS.backup_finish_date DESC