If you are using Veeam to manage ALL of your SQL Server backups, then this would be okay, however if you are also using the standard SQL Server backups this breaks the restore chain, and prevents you from restoring any of your normal transaction log backups past the time the Veeam backup occurred. If you don’t know where to get that transaction log file, what Veeam has done is just made it impossible for you to restore your normal transaction logs backups past the time the Veeam backup occurred. If you are the Veeam backup admin and know where to find that backup, and to use it in a log restore situation, then you might get away with that setting. If you choose to process transaction logs with the job, Veeam takes a transaction log backup with the full snapshot backup, and stores that transaction log backup, somewhere in the Veeam backup system. The settings dialog looks something like this depending on the version of Veeam you are using. If Veeam is installed for backing up the entire VM that is running SQL Server, there is an option for Veeam to backup the SQL Server database, and to “Process transaction Logs”, or “Peform copy only. The problem is that by default it doesn’t play well with SQL Server backups. It allows for some really great snapshot backup and restore capability. It is commonly used in VMWare environments, and some in HyperV environments. Veeam is a really incredible tool for backing up virtual machines. The example below is written for Veeam, hower similar things apply to other backup and VM Snapshot tools. Veeam or other backup tools may be stomping on SQL Server Backups.

Veeam backup restore