| SELECT sdb.Name AS DatabaseName, | |
| COALESCE(CONVERT(VARCHAR(12), MAX(bus.backup_finish_date), 101),'-') AS LastBackUpTime | |
| FROM sys.sysdatabases sdb | |
| LEFT OUTER JOIN msdb.dbo.backupset bus ON bus.database_name = sdb.name | |
| GROUP BY sdb.Name |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment