Dup to Tape does not get all Transaction Logs
My current job definition is:
- backup our User Database with a Full every night.
- transaction logs run throughout the day.
- Duplicate to Tape set to occur on weekend. Source selected is "All backups"
My issue is that when duplicate to tape runs, it only does a "dup to tape" of the transaction logs since the last database full backup.
Do I have to manually "dup to tape" the other backup sets?
(12 transaction logs/day x 6 days is 72 backup sets for each MSSQL Server!)
Ideas or suggestions are always welcome.