Application-Aware Processing

To configure transaction log handling settings, do the following on the Guest Processing step of the backup job wizard.

1. Select the Enable application-aware processing check box.
2. In the Guest OS credentials section, specify the account that will be used to perform the log handling operations on guest operating system of the SQL Server VM, including truncation and backup (i.e. shipment to repository).

For log backup, this account should have the sysadmin server role assigned on that SQL Server VM. See also this Veeam KB article. This is the recommended setting; however, if you need to provide minimal permissions to the account performing backup operation, you can assign the following:

• SQL Server instance-level roles: dbcreator and public
• Database-level roles: db_backupoperator, db_denydatareader, public; for system databases (master, model, msdb) - db_backupoperator, db_datareader, public
• Securables: view any definition, view server state

For truncation of SQL Server 2012 or SQL Server 2014 database transaction logs, this account should have the db_backupoperator database role (minimal required) or the sysadmin server role.

3. Then click the Application button, select the SQL Server VM in the list of processed machines, and click Edit to open its processing settings.
4. On the General tab, in the Application section, select Require successful processing (recommended) option – this will instruct Veeam to stop the backup process if any VSS errors occur during application quiescence.