The below scripts which allow you to find SQL Server Database Last night backup history. If you want see more files in this list please change date.
SELECT
[Server_name],
[Database_name],
[Type] AS Backup_type,
case
when [type]= 'D' THEN 'Full Backup'
when [type]= 'I' THEN 'Incremental Backup'
when [type]= 'L' THEN 'Log Backup'
end as Backup_types ,
CAST(backup_size /1048576 AS DECIMAL (10,2)) AS [Backup_Size (MB)],
CAST(compressed_backup_size/1048576 AS DECIMAL (10,2))
AS [Compressed_Backup_Size (MB)],
CAST(compressed_backup_size/1048576 AS DECIMAL (10,2))/1024 AS [Compressed_Backup_Size (GB)],
100- ((compressed_backup_size/backup_size)*100) AS 'Compressed%',
[backup_start_date],
[backup_finish_date]
FROM msdb.dbo.backupset
WHERE [Type]='D'
and backup_finish_date> getdate()-1 -- '2025-04-01 00:00:00.000'
ORDER BY backup_set_id desc
