Backup two jobs to tape library
So we currently have backup exec 2010 R3 setup to run a full backup once a week and a diff daily. The server is connected to a robotic library that holds 8 LTO4 tapes. Currentlly when a job runs if a tape gets full it pulls a second tape and continues to write the backup data.
We are currently using AOFO for both the diff and the full jobs. We have had some issues backing up sql and some have contributed this to using AOFO.
I would like to create two jobs one for data and one for sql and exchange without AOFO enabled. The problem is I don't know how to set this up so that it will use tapes as it always has. If I create a new job it will create a new tape for each job. So it adds one extra tape to every backup that is a long ways from full.
Is ther anyway of telling backup exec to append to the last tape it used instead of pulling a new tape? It currently appends or overwrites the tape with the oldest data.
Hopefully thats not too confusing.