If you have two drives in a standard drive pool, and your job fills the tape in one drive, backup exec will prompt you to swap tapes in the drive that was selected
with a cascaded drive pool of two drives, if the job fills the first tape, it will continue on the second drive with no interaction from you (as long as there is an overwritable tape in both drives ;) )