SQL SERVER – Finding Last Backup Time for All Database

Useful script to find last backup time for all db's in SQL Server:

SELECT sdb.Name AS DatabaseName,

COALESCE(CONVERT(VARCHAR(20), MAX(bus.backup_finish_date), 120),'-') AS LastBackUpDateTime,

COALESCE(CONVERT(VARCHAR(12), MAX(bus.backup_finish_date), 101),'-') AS LastBackUpDate

FROM sys.sysdatabases sdb

LEFT OUTER JOIN msdb.dbo.backupset bus ON bus.database_name = sdb.name

GROUP BY sdb.Name

Source: http://blog.sqlauthority.com/2010/11/04/sql-server-finding-last-backup-time-for-all-database/