SQL SERVER – Finding Last Backup Time for All Database

SELECT sdb.Name AS DatabaseName,COALESCE(CONVERT(VARCHAR(12), MAX(bus.backup_finish_date), 101),'-') ASLastBackUpTimeFROM sys.sysdatabases sdbLEFT OUTER JOIN msdb.dbo.backupset bus ON bus.database_name = sdb.nameGROUP BY sdb.Name

-------------------------

URL:

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