T-SQL Query to retrieve the last full backup (Including split and copy only), Size and Location
For copy only backups, just remove this condition in the WHERE clause:
AND A.is_copy_only = 0

By &quot;split backup&quot;, I assume you mean that you have something that is using VSS to create a snapshot backup? Are you 100% certain that this isn't in the result? I don't have such a backuphistory to play with at the moment, but I suggest you start by doing SELECT from backupset and see if those backups are present. If they are, it should be pretty easy to adjust the SQL based on that. If they aren't, then you probably do a snapshot backup without SQL server knowing it, and those aren't considered valid backups from SQL Server's viewpoint (potentially corrupt databases if you restore from such a backup).