Script to find the list of database name whose backup is not happened for the past one day

Run the below command and it will list out all the database name that have not been backed up since yesterday.

use msdb;

SELECT  backupset.database_name,backupset.backup_start_date,backupmediafamily.physical_device_name,(backupset.backup_size/1024)/1000 as size

FROM   backupset,backupmediafamily where backupset.media_set_id = backupmediafamily.media_set_id

and datediff(dd,backupset.backup_start_date,getdate()) < 1 and database_name like '%%' order by backupset.database_name,backupset.backup_start_date desc