Find Database(s) backup history in SQL Server

Below query will provide you with history of all Backups taken for a Database in SQL Server, Details include, Name, Type, Path of backup, Backup start time and end time, Backup size and more: 

SELECT 
  CONVERT(
    CHAR(100), 
    SERVERPROPERTY('Servername')
  ) AS Server, 
  msdb.dbo.backupset.database_name, 
  msdb.dbo.backupset.backup_start_date, 
  msdb.dbo.backupset.backup_finish_date, 
  msdb.dbo.backupset.expiration_date, 
  CASE msdb..backupset.type WHEN 'D' THEN 'Database' WHEN 'L' THEN 'Log' END AS backup_type, 
  msdb.dbo.backupset.backup_size, 
  msdb.dbo.backupmediafamily.logical_device_name, 
  msdb.dbo.backupmediafamily.physical_device_name, 
  msdb.dbo.backupset.name AS backupset_name, 
  msdb.dbo.backupset.description 
FROM 
  msdb.dbo.backupmediafamily 
  INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id 
WHERE 
  msdb.dbo.backupset.database_name = 'master' --(CONVERT(datetime, msdb.dbo.backupset.backup_start_date, 102) >= GETDATE() - 7)
  and msdb..backupset.type = 'D' 
ORDER BY 
  msdb.dbo.backupset.database_name, 
  msdb.dbo.backupset.backup_finish_date desc;

Here is the result set of master database backup history: