Help Center
Choose product document...
Veeam Backup & Replication 9.5
Enterprise Manager User Guide

Preparing an Application-Consistent Backup

To provide for recoverability of SQL database, make sure you have an application-consistent backup (with VSS enabled) of your SQL server VM created successfully. Also, if you plan to restore the database to its state as of the certain point in time (not necessarily the restore point, that is, backup or replica), then transaction log processing should be configured, as described below, as well as in the Veeam Backup & Replication User Guide.

To configure corresponding job settings, you can do the following in Enterprise Manager:

  1. Go to the Jobs tab and select your SQL server backup job.
  2. Click Job actions on the toolbar and select Edit job to start the job wizard.
  3. Proceed to the Guest processing step of the wizard and make sure the Enable application-aware image processing check box is selected.
  4. Click the Applications button, then in the dialog displayed, select the SQL server VM from the list and click Edit.
  1. On the General tab, make sure you have the Require successful application processing option selected in the Applications section.
  1. Also, to be able to specify transaction log handling options, make sure the Process transaction logs with this job (recommended) option is selected. Otherwise, if you select Perform copy only (lets another application use logs) option, Veeam Backup & Replication will create a copy-only backup, and transaction logs will not be purged – that is why the SQL tab with log handling settings will be deactivated in this case. To read mode, refer to the copy-only backup description in the Veeam Backup & Replication User Guide.

Preparing an Application-Consistent Backup 

  1. Next, go to the SQL tab and specify how SQL transaction logs will be handled:
  • Select Truncate logs (prevents logs from growing forever) if you want Veeam Backup & Replication to trigger truncation of transaction logs only after the job is finished successfully. If truncation of transaction logs is not possible for some reason, the logs will remain untouched in the VM guest OS until the next start of the Veeam runtime process responsible for application-aware processing.
  • Select Do not truncate logs (requires simple recovery model) if you do not want Veeam Backup & Replication to truncate logs at all.
  • Select Backup logs periodically (backed up logs are truncated) if you need to backup transaction logs of SQL server VM, storing them to backup repository next to server backup. After transaction logs are placed to repository, they will be truncated on guest. With this option selected, you should also specify how often Veeam will process these transaction logs, uploading them to repository. To set the processing frequency, enter the required value in the Backup logs every <N> minutes field (default is every 15 minutes).

Preparing an Application-Consistent Backup 

Preparing an Application-Consistent Backup Important!

  • If you prefer the Do not truncate logs option, make sure the recovery model for the necessary databases on the SQL server is set to simple (otherwise, logs may drastically increase in size).
  • For Backup logs option to take effect, you should ensure that full or bulk-logged recovery model is turned on for the required databases on the SQL server VM. If recovery model is set to simple, no transaction logs will be backed up. If full model is enabled but neither Backup logs nor Truncate logs option is selected, then logs will increase in size and occupy disk space.

The last option allows you to restore SQL database to selected restore point or to selected point in time, using Enterprise Manager. Restore to specific transaction can be performed using Veeam backup management console. To read more, refer to the Veeam Backup & Replication User Guide.

  1. If you selected to backup transaction logs, specify how long they should be kept, using the Retain log backups options.

Preparing an Application-Consistent Backup Important!

It is recommended to keep logs Until the corresponding  image-level backup is deleted; otherwise, you should manually check and ensure that your database and log backup retention policies are consistent, providing all the VM restore points and log backups required for database restore.

  1. Click OK to save the settings and close the dialog.
  2. On the Job schedule step, make sure the scheduled run is enabled for the job, otherwise, log backup will not be activated.
  3. Finish the wizard.
Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Backup Explorers User Guide

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide

Veeam Backup for Microsoft Office 365

Veeam ONE Documentation

Veeam Endpoint Backup Documentation

Veeam Management Pack Documentation