My first question is why does Job Monitor says backup missed if the tape are in the tape drive? Where do I find back exec logs?
Double-click on the job in the Job History window and the job log will appear. The reason for the failure will be in the job log
Also there are some Media label sets that have a red X on on them. How do I re-enable them?
These media are offline, i.e. they are are not available for use. For example, tapes that have been moved off-site. When you return them and they are available, the X will disappear.
Does it matter which Media label set I use for tape backups?
Yes. Because the media set contains the Overwrite Protection Period which determines how long is your data protected.
I would strongly suggest that you acquaint yourself with the Admin Guide which can be found in the BE installation directory.