Last Backup for All Databases In SQL Server

This Blog will explain how to get the last back up data of 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.