For the occasions that you need to check the backup history of your SQL Instance this script is helpful.
/******************
* Title: View Latest Backup History
* Notes: Provides detail on the last backups and when they took place.
*******************/
SELECT
bs.[database_name] AS DatabaseName
,bs.backup_start_date AS DateStart
,bs.backup_finish_date AS DateFinished
,DATEDIFF(MI, bs.backup_start_date, bs.backup_finish_date) AS DurationMin
,DATEDIFF(SS, bs.backup_start_date, bs.backup_finish_date) AS DurationSec
,CASE bs.[type]
WHEN 'D' THEN 'Full Backup'
WHEN 'I' THEN 'Differential Database'
WHEN 'L' THEN 'Log'
WHEN 'F' THEN 'File/Filegroup'
WHEN 'G' THEN 'Differential File'
WHEN 'P' THEN 'Partial'
WHEN 'Q' THEN 'Differential partial'
END AS BackupType
,CAST(ROUND(((bs.backup_size/1024)/1024),2) AS decimal(18,2)) AS BackupSizeMb
,CAST(
ROUND(((bs.compressed_backup_size/1024)/1024),2)
AS decimal(18,2)) AS CompressedBackupSizeMb
,''
+ ISNULL(
CASE WHEN has_bulk_logged_data = 1 THEN '| Bulk Logged Data' END
+ CASE WHEN is_snapshot = 1 THEN '| Snapshot' END
+ CASE WHEN is_readonly = 1 THEN '| Read-Only' END
+ CASE WHEN is_single_user = 1 THEN '| Single User' END
+ CASE WHEN has_backup_checksums = 1 THEN '| Backup Checksums' END
+ CASE WHEN is_damaged = 1 THEN '| Damaged' END
+ CASE WHEN begins_log_chain = 1 THEN '| Begins Log Chain' END
+ CASE WHEN begins_log_chain = 1 THEN '| Incomplete Metadata' END
+ CASE WHEN is_force_offline = 1 THEN '| Force Offline' END
+ CASE WHEN is_force_offline = 1 THEN '| Copy Only' END
,'') AS BackupOptions
,bmf.physical_device_name AS BackupFile
,bs.[user_name] AS ExecUser
,CASE
WHEN bs.database_name IN ('model','master','tempdb','msdb')
THEN 1
ELSE 0
END AS IsSystemDatabase
FROM msdb.dbo.backupmediafamily AS bmf
INNER JOIN msdb.dbo.backupset AS bs ON bmf.media_set_id = bs.media_set_id;
GO
