Veeam Backup Repositories

Veeam Plug-ins store backup files in repositories added to the Veeam Backup & Replication infrastructure. This section lists supported types of backup repositories and limitations for Veeam Plug-in for Microsoft SQL Server backups.

Supported Backup Repositories

Veeam Plug-in for Microsoft SQL Server supports integration with the following types of repositories added to the Veeam Backup & Replication infrastructure:

If you plan to use HPE StoreOnce as a backup repository for Veeam Plug-in backups, the total number of stored files (data and metadata) must not exceed 3,000,000 per Catalyst store. If necessary, multiple Catalyst stores may be created on the same StoreOnce system.

You can also use scale-out backup repositories that contain supported repository types.

Backup Repository Limitations

To configure the warning settings, add the following parameter in the veeam_config.xml file.

<PluginParameters repositoryFreeSpacePercentWarning="10" />

If you want to use the same backup target with the repository-based encryption and Veeam Plug-ins, create a second repository in the subfolder for Veeam Plug-in backups.

  • Veeam extract utility cannot extract Veeam Plug-in backup files. By design of Microsoft SQL Server, these files cannot be imported “as files” to RMAN as they contain additional metadata bound to the used SBT device.

Veeam Scale-Out Backup Repositories

If you want to store Veeam Plug-in backups in scale-out backup repositories, consider the following:

  • You cannot rename a scale-out backup repository with Veeam Plug-in backups stored on this repository.
  • If you want to add a backup repository as an extent to a scale-out backup repository and Veeam Plug-in backups are present on this backup repository, you must do the following:
  1. In the Veeam Backup & Replication console, select Veeam Plug-in backup files that reside in this backup repository and remove them from configuration. For details, see Removing Backups from Configuration. Note that this action does not delete the backups from the repository.
  2. In the Veeam Backup & Replication console, delete the Veeam Plug-in backup job. For details, see Deleting Jobs.
  3. Add the repository as an extent to the scale-out repository. For details, see Extending Scale-Out Repositories.
  4. Rescan the scale-out repository. For details, see Rescanning Scale-Out Repositories.

Note

Make sure that names of backup files and paths to backup files meet the following requirements:

  • The names of all backup files (VAB, VASM, VACM) and paths to these files contain only allowed alphanumeric (a-zA-Z0-9) and special (_-.+=@^) characters.
  • The names of backup job metadata files (VASM) and paths to these files do not contain spaces. If names or paths contain spaces, replace them with underscores.
  1. On the Veeam Plug-in server, set the scale-out repository as the target for backups using the following command:

MSSQLConfigTool --set-repositories

  1. Map the imported backups using the following command:

MSSQLConfigTool --map-backup

  • For Veeam Plug-in backups and backup copies, the Performance policy of a scale-out repository functions differently:
  1. Veeam Backup & Replication checks if there are extents without warning on free space insufficiency. If all extents have the warning, Veeam Backup & Replication uses an extent with the largest amount of free space that has a free task slot.
  2. If there are extents without the warning, Veeam Backup & Replication checks if there are incremental extents with free task slots. If there are no incremental extents with free task slots, Veeam Backup & Replication uses a full extent with the least amount of used task slots.
  3. If there are incremental extents with free task slots, Veeam Backup & Replication sends backup files to an incremental extent with the least amount of used task slots. If the amount of used tasks is the same, an extent with the largest amount of free space.

To learn more about file placement policies of scale-out repositories, see Backup File Placement section of the Veeam Backup & Replication guide.

  • If a scale-out repository is configured in the Data locality policy, repository extents will be selected according to the largest amount of free space for each Microsoft SQL Server connection. If the selected extent does not have free task slots, Veeam Backup & Replication uses the extent with the next largest amount of free space. If there are two extents with only one slot on each extent, the backup will be launched on two streams (one on each extent).

Capacity Tier

You can configure Veeam Backup & Replication to transfer Veeam Plug-in backup files to the capacity tier. Both policies (Move policy, Copy policy) are supported for Veeam Plug-in backups with the following limitations:

  • For Veeam Plug-in backup files, capacity tier does not verify whether data that is being moved is unique and has not been offloaded earlier. Thus, it is highly recommended to check the pricing plans of your cloud storage provider to avoid additional costs for offloading and downloading backup data.
  • To offload Veeam Plug-in backup files to the capacity tier, Veeam Backup & Replication splits data into 1 MB objects and compresses the resulting objects. The default object size will be a compressed 1 MB block, resulting in objects of around 512 KB in size.
  • [For the Move policy] For Veeam Plug-in for Microsoft SQL Server backups, capacity tier tracks dependencies of full and differential backup files. Thus, Veeam Backup & Replication tracks inactive backup chains and moves them to the capacity tier. No limitations apply to the operational restore window.
  • [For the Copy and Move policies] For Veeam Plug-in for Microsoft SQL Server backups, Veeam Backup & Replication copies to the capacity tier only those backup files for which 24 hours have passed since the backup file was created.
  • If a scale-out repository is down, you cannot restore from the Veeam Plug-in backup files stored on the capacity tier. In this case, you can only import the backup files to Veeam Backup & Replication manually and then perform data recovery operations.
  • If you use a capacity tier that has been created in Veeam Backup & Replication version 10, you cannot transfer Veeam Plug-in backup files to a capacity tier. However, if you want to transfer them manually, do the following:
  1. If the backup files are created by Veeam Plug-in version 10, upgrade the metadata of backup files as described in the Upgrading Metadata Files to New Format section.
  2. Run the Set-VBRScaleOutBackupRepository PowerShell command with the -EnablePluginBackupOffload parameter to offload backup files to the capacity tier.

Hardened Repository

You can configure Veeam Backup & Replication to transfer Veeam Plug-in backup files to a hardened repository. The hardened repository helps to protect Veeam Plug-in backup files from loss as a result of malware activity or unplanned actions. Backup files in the hardened repository become immutable for the time period specified in the backup repository settings. During this period, backup files stored in the repository cannot be modified or deleted.

For Veeam Plug-in for Microsoft SQL Server backups, immutability works according to the following rules:

Data Restore from Hardened Repository

As a result of malware activity or unplanned actions, backup job metadata (VACM) files may become unavailable in the hardened repository. In this case, to restore data from the hardened repository, you must re-create the VACM file. To do this, complete the following steps:

  1. Run a Veeam Plug-in backup job to create a new Veeam Plug-in backup in a Veeam backup repository. The backup will consist of the VAB, VASM and VACM files.
  2. In the backup repository folder, replace the VAB and VASM files created at the step 1 with the VAB and VASM files from the hardened repository.
  3. In the Veeam backup console, run the backup repair operation. Veeam Backup & Replication will generate a new VACM file using information from the VASM files. For details, see Repairing Backup.

Once the backup job metadata file is re-created, you can use Veeam Plug-in to restore your data.