Where does SSMS Last database backup date come from?
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