Where does SSMS Last database backup date come from? The backup date for several of my databases do not appear in msdb.dbo.back upset yet the correct date appears in SSMS when I select a db name, right click, properties, there in the general tab is the correct date. Where does SQL Server get this date?
Where does SQL Server get this date?


SSMS behind the scenes uses msdb.dbo.backupset to populate the data in the Properties page Last Database Backup. Note that the SSMS properties page does not give info about filegroup backup. It only gives info about full, diff or log backup.

You can use this script to retrieve SQL Server database backup history and no backups details