To list the backup devices for your system, run:
select * from master..sysdevices where status = 16 or status = 24
To list both the physical and logical names for database and backup devices, use sp_helpdevice:
sp_helpdevice tapedump1
device_name physical_name description status cntrltype device_number low high ------ --------- ------------- -------- ------- tapedump1 /dev/nrmt4 tape, 625 MB, dump device 16 3 0 0 20000
