Try this script, it states the start and end timestamp of each DB backup

USE [msdb]

GO

SELECTrs.[destination_database_name],

rs.[restore_date],

bs.[backup_start_date],

bs.[backup_finish_date],

bs.[database_name] AS [source_database_name],

bmf.[physical_device_name] AS [backup_file_used_for_restore]

FROM[dbo].[restorehistory] rs

JOIN[dbo].[backupset] bs

ON rs.[backup_set_id] = bs.[backup_set_id]

JOIN[dbo].[backupmediafamily] bmf

ON bs.[media_set_id] = bmf.[media_set_id]

ORDER BY rs.[restore_date] DESC

GO