Listing the current device names

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