napstr4u (Black Edition): select * from sys.backup

select * from sys.backup_devices

Contains a row for each backup-device registered by using sp_addumpdevice or created in SQL Server Management Studio.

select * from sys.backup_devices;

Column names

name: Name of the backup device. Is unique in the set.
type: Type of backup device:
type_desc: Description of backup device type:
physical_name: Physical file name or path of the backup device.

Pages

select * from sys.backup_devices