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.
Veeam Plug-in for Microsoft SQL Server supports integration with the following types of repositories added to the Veeam Backup & Replication infrastructure:
- HPE StoreOnce. 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.
- For Veeam Plug-in backups, the warning which indicates that free space on a storage device has reached a specified threshold is configured in the veeam_config.xml file of Veeam Plug-in. The warning settings in the Veeam Backup & Replication console does not affect this setting.
To configure the warning settings, add the following parameter in the veeam_config.xml file.
<PluginParameters repositoryFreeSpacePercentWarning="10" />
- The plug-in configuration wizard will not show repositories where the Encrypt backups stored in this repository option is enabled. To learn how to disable the encryption option, see Access and Encryption Settings on Repositories.
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, mind the following:
- 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:
- 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.
- In the Veeam Backup & Replication console, delete the Veeam Plug-in backup job. For details, see Deleting Jobs.
- Add the repository as an extent to the scale-out repository. For details, see Extending Scale-Out Repositories.
- Rescan the scale-out repository. For details, see Rescanning Scale-Out Repositories.
Names of backup files and paths to backup files must contain only allowed characters:
- On the Veeam Plug-in server, set the scale-out repository as the target for backups using the following command:
- Map the imported backups using the following command:
- For Veeam Plug-in backups and backup copies, the Performance policy of a scale-out repository functions differently:
- 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.
- 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.
- 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 amount of free space for each Microsoft SQL Server connection. If there are two extents with one slot on each extent, the backup will be launched on two streams (one on each extent).
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.
- [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:
- If the backup files are created by Veeam Plug-in version 10, upgrade the metadata of backup files as described in Upgrading Metadata Files to New Format.
- Run the Set-VBRScaleOutBackupRepository PowerShell command with the -EnablePluginBackupOffload parameter to offload backup files to the capacity tier.
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:
- Immutability is applied to backup (VAB) files and backup metadata (VASM) files. Backup job metadata (VACM) files are not immutable.
- Backup files become immutable for the configured time period (minimum 7 days, maximum 9999 days).
- The count of the immutability period starts after 24 hours have passed since the backup file was created. Every 1 hour, the immutability service that runs in the background detects backup files that are older than 24 hours and sets the immutability flag on such backup files.
- The immutability period is automatically extended for backup files that contain restore points of the active chain.
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:
- 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.
- 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.
- 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.