Help Center
Choose product document...
Veeam Backup & Replication 9.0
Backup and Restore of SQL Server Databases

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.

Application-Aware Processing Note:

As for SQL Server 2005, 2008 and 2008 R2 database transaction logs truncation, the local SYSTEM account will be used by default – in these versions, default settings allow for log truncation by local SYSTEM account; however, if they were modified, make sure this account is permittied to truncate logs. See also this Veeam Knowledge Base article.

Application-Aware Processing 

  1. Then click the Application button, select the SQL Server VM in the list of processed machines, and click Edit to open its processing settings.
  2. 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.

Application-Aware Processing 

Application-Aware Processing Note:

If you want to continue the backup process even if VSS errors occur, you can select Try application processing but ignore failures – this option is recommended to guarantee completion of the job; however, the created backup image will be only crash-consistent.

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Administrator Guide

Veeam Backup Explorers User Guide

Backup and Restore of SQL Server Databases

PowerShell Reference

RESTful API Reference

Veeam Direct Restore to Microsoft Azure

Veeam Backup FREE Edition User Guide

Veeam ONE Documentation

Veeam Endpoint Backup Documentation

Veeam Management Pack Documentation