If I run SELECT * FROM msdb.dbo.BACKUPSET it includes the name of the backup set. That name is the name assigned with the parameter of 'name' in the t-sql backup command.
Is there another SQL table that contains the name of the backup file that shows up in Windows explorer?
BACKUP LOG BACKUPSAMPLE TO DISK = 'F:\BACKUPSAMPLE_LOG4.BAK' with name = 'backupsample log backup 128'
I am interested in 'BACKUPSAMPLE_LOG4.BAK' and if possible, the location of the backup?