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