/*
 * list of database and last backups
 * order by db creation 
 */
select name,create_date, bs.last_backup from sys.databases  dd
left join (select database_name, MAX(database_creation_date) db_creation, MAX(backup_start_date) last_backup   from msdb.dbo.backupset bs group by bs.database_name) bs
on (bs.database_name = dd.name)
order by create_date desc