https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/backupmediafamily-transact-sql?view=sql-server-2017
backupmediafamily (Transact-SQL) - SQL Server | Microsoft Learn
Reference for backupmediafamily, which contains one row for each media family.
sql servertransactmicrosoftlearn