Required Job Settings

This requirement applies to backup jobs, replication jobs, and CDP policies created by Veeam Backup & Replication.

When you create a job or CDP policy, make sure to enable application-aware processing in the Veeam Backup & Replication console:

Note that when you create storage snapshots, application-aware processing is automatically enabled. For more information, see the Application Item Restore from Storage Snapshots section of the Veeam Backup & Replication User Guide.

Configuring Transaction Logs

For more information about configuring transaction logs, see the Microsoft SQL Server Transaction Log Settings section of the Veeam Backup & Replication User Guide. Note that backups of transaction logs are only available for backup jobs created by Veeam Backup & Replication.

Recovery Model

Note

To be able to restore your data as of a point in time or as of a state before undesired transactions, make sure the recovery model for the database is set to full or bulk-logged.

The following table lists database logging models and applicable Veeam options.

SQL DB Logging Model

Veeam Options

 

Truncate logs

Do not truncate logs

Backup logs periodically

Simple

Databases are skipped from processing.

Applicable option.

Databases are skipped from processing.

Log files do not grow (and do not need to be backed up).

Full

Applicable option.

Veeam performs “backup to NUL” for log files on guest.

Applicable but not recommended to use without native or 3rd party means of log truncation or backup – otherwise, logs will increase in size.

Applicable option. Log backup files (.BAK) are copied from the temporary folder on the Microsoft SQL Server to a Veeam repository. As soon as the data is copied to the target, BAK files are deleted from the source.

Bulk-logged

Applicable option.

Veeam performs “backup to NUL” for log files on guest.

Applicable but not recommended to use without native or 3rd party means of log truncation or backup – otherwise, logs will increase in size.

Applicable option. Log backup files (.BAK) are copied from the temporary folder on the Microsoft SQL Server to a Veeam repository. As soon as the data is copied to the target, BAK files are deleted from the source.