I have taken a copy only full backup using the query
BACKUP DATABASE abc TO DISK = N'E:\Backup\abc.bak' WITH COPY_ONLY,COMPRESSION
And when I try to check this information via the query,
SELECT top 100 * FROM msdb.dbo.backupset a with(nolock) INNER JOIN msdb.dbo.backupmediafamily b with(nolock) ON a.media_set_id = b.media_set_id WHERE is_copy_only = 1 ORDER BY a.database_name desc, a.backup_finish_date desc
...the name of the backup I just took can't be found in the
name column, instead NULL is being returned. However the path to the backup is listed in the physical_device_name column. I am unable to figure out why name of the backupset is being returned as NULL.