Last Backup for All Databases In SQL Server

Open SQL server and write following query;

SELECT a.Name AS [DB_Name],

COALESCE(CONVERT(VARCHAR(12), MAX(b.backup_finish_date), 101), '-') AS LastBackup

FROM sys.sysdatabases a

LEFT OUTER JOIN msdb.dbo.backupset b ON b.database_name = a.name

GROUP BY a.Name

The above query will show the last backup data of all databases as you can see it in following image.