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.
Join the conversation! Your thoughts help the community grow.