My question is, if we are excluding SQL data volumes from the original backup job, can we still do full SQL backups and transaction logs using application-aware processing?
For some background, in our current state my team is backing up our Windows SQL VMs using a Backup job, then use a Backup Copy job to get those offsite. Since the team has historically ran SQL Agent jobs to do daily full and hourly log backups for each DB they decided to exclude any volumes storing SQL data from the Veeam Backup job. I see the reasoning and I suppose this works, but I’d like to shift to including Veeam on SQL backups so we can easily get those offsite using the existing backup copy jobs.
Finally, a sort of related question, if we can use Veeam and the SQL agent jobs in tandem, which one should truncate those? In my testing I’ve had to set the SQL Agent job to copy only mode for things to work, but I feel like setting Veeam to copy only mode should work as well, but I must be missing something since I get errors each time I try that.
