I've been working with one of our end users on getting their SQL servers converted to use Veeam backups, to be consistent with their standard backup strategy. I've been working with support (Case # 00976504) to get assistance with backup configuration options, and am generally pleased with the response time and knowledgeability of my support agent, Michael.
However, I recently uncovered (via trial and error on my test system) that the hourly SQL Log backups did not appear to be copying with the Backup Copy job we have set up for this system. Michael confirmed that the copy job won't grab the log backups, and suggested a file copy. When I asked how the restore process would work if we lost the main site altogether (e.g. a fire), I was told "the SQL log backups produced by Veeam will only work with the backup job they are associated with and not the backup copy job, even if they are copied offsite with the backup copy." This is a huge problem for us, as it means we cannot meet our 1 hour RPO for these SQL servers.
I was directed here to make a feature request for having SQL Log files available in the offsite copy. But honestly, I feel like this is a show-stopping lack of functionality, more along the lines of a critical bug! Without the offsite backup having a copy of my SQL Transaction Log backups that can be used in a restore operation, I cannot meet any RPO shorter than 1 day using Veeam's Application Aware SQL backups. I don't have any on-premise Exchange servers being backed up with Veeam, so I can't confirm whether or not the same limitation exists for that Application Aware backup mode, but if it does, I believe you need to resolve it ASAP.