This little script may be useful to others making backups to multiple removable disks.
The main problem with this approach is that there is no place within BE's GUI and no report to find out on which of your removable disks a certain media file is present.
You have the location column within the media overview which carries the backup-to-disk-folder name where a certain media file is present however this information is not persistent, meaning it only shows the medias for the disk which is currently plugged in and vanishes for all offline b2d folders if you start an inventory job or restart BE services.
So what to do if you choose some files you want to restore from within BE and the only thing BE tells you is that these files are located on media B2D001486? Plug in one removable disk after the other, start an inventory job, and see if the media file in question appears in the device view.
This is the point where this litte script jumps in. It collects the information on which b2d-folder a media is stored and writes it into the media description field.
This way the information is made persistend and can be viewed within the GUI or a report.
Simply run the script once a day after all backups are done.
The script is written for BackupExec 2010 R2 and requires MSSQL 2008 or 2008 R2 as it uses MSSQL's native client.