Script to get all backup of a SQL Server database

sql-get-db-backups.sql

declare @dbName varchar(255);

set @dbName = 'TestDB';

SELECT          m.physical_device_name,
                b.backup_start_date,
                b.backup_finish_date,
                b.type,
                b.backup_size/1024/1024 AS BackupSizeMB,
                b.compressed_backup_size/1024/1024 as CompressedBackupSizeMB
FROM msdb.dbo.backupset b
JOIN msdb.dbo.backupmediafamily m ON b.media_set_id = m.media_set_id
WHERE b.database_name = @dbName
ORDER BY backup_finish_date DESC

To check if a file is existing by sql:

DECLARE @Result INT
EXEC master.dbo.xp_fileexist 'D:\Wip\Practices\OpenSource\FolderListioning\FolderToWatch\Config.txt', @Result OUTPUT
print @Result