FROM msdb.dbo.backupset b
JOIN msdb.dbo.backupmediafamily m ON b.media_set_id = m.media_set_id
WHERE database_name like '%%'
ORDER BY backup_finish_date DESC
Joe's Knowledge Base - A Collection of Various Tips-N-Tricks (Software) that I really get tired of having to find again each time I need them. Now ... where did I (put/find) that ...