Operational Defect Database
BugZero found this defect 2539 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Veeam | kb2301
How to Deploy Veeam Configuration Database in SQL AlwaysOn Availability Group
Last update date:
4/13/2022
Affected products:
Veeam Backup & Replication
Affected releases:
11
Fixed releases:
No fixed releases provided.
Description:
Purpose
This article provides information on using a SQL AlwaysOn Availability Group to host the Veeam Backup & Replication and/or Veeam Backup Enterprise Manager configuration database(s).
Solution
Configuration Notes It is best practice to keep the Veeam Backup & Replication application and its configuration database on the same server to maintain the lowest latency and highest performance.[1] The included SQL Express instance is considered adequate for protecting up to 500 machines.[2] The best way to protect the Veeam Backup & Replication configuration database is to use the built-in Configuration Backup. Hosting the Veeam Backup & Replication configuration database on a remote SQL Instance may negatively impact the performance of the Veeam Backup & Replication software. The Veeam Backup & Replication configuration database is highly transactional, and network congestion could delay communication with the configuration database. Please be advised that SQL AlwaysOn Availability Groups require the databases to be in Full Recovery mode. Veeam Backup and Replication does not currently truncate its database, as we expect it to be in simple recovery mode. This will require you to manually truncate the SQL log file to ensure it doesn't grow too large.
More Information
Contact your database administrator, if necessary. How to migrate Veeam Backup & Replication or Veeam Backup Enterprise Manager Veeam Backup & Replication Configuration Database Best Practices
