I am using the following query answered by Marcello Miorelli. This query serves the purpose for normal backups but fails to determine the actual backup size of all the split backups and copy only backups. Ideally, I want to have the list of all the database backup information (Size, Last backup date, location) including split and copy-Only backups.
Can anyone help me tweak this bug to fetch the accurate database backup size.