Backup using more tapes than it should
Hi,
I currently run a weekly backup of our servers that is ~3TB is size, onto LT04 tapes. Even if there is zero compression, that should only take around 4 tapes. Currently it takes usually 6, but sometimes 7. Just wondering if anyone has run into a similar problem or knows where I may have a setting wrong to cause it to span so many tapes.
Basic rundown of backup:
Using Backup Exec 2014
Run 4 seperate backup jobs
Backing up 3 servers with a normal backup agent + 1 SQL Server
Noticed recently that even though the SQL server job is less than 100GB it takes more than 1 tape to get the backup for that server completed, and the 1 server with >1TB of data takes 3+ tapes
I have tried doing 1 job for all 4 servers, which cut down the tapes but stuffed up the daily differentials, so reverted to individual jobs to ensure we have a proper differential job each day
Could I run the 1 job for all servers as the full backup, then the 4 seperate jobs for the daily differential?
TIA