Hi,

Take a look at this query , it might help !

SELECT TOP (10) *

FROM

msdb.dbo.backupmediafamily AS fm

INNER JOIN msdb.dbo.backupmediaset AS ms ON fm.media_set_id = ms.media_set_id

INNER JOIN msdb.dbo.backupfile AS bf

INNER JOIN msdb.dbo.backupset AS bcs ON bf.backup_set_id = bcs.backup_set_id ON ms.media_set_id = bcs.media_set_id