1-800-691-1991 | 9am - 8pm ET
EN

Setting up Veeam configuration database in SQL AlwaysOn Availability Group

KB ID: 2301
Product: Veeam Backup & Replication 10a, Veeam Backup & Replication 9.5, Veeam Backup & Replication 9.0, Veeam Backup & Replication 8.0, Veeam Backup & Replication 7.0
Published: 2017-06-07
Last Modified: 2020-11-20

Challenge

Run Veeam Backup and Replication database or Veeam Enterprise Manager database in SQL AlwaysOn Availability Group

Solution

If you want to deploy the Veeam Backup & Replication database (default name VeeamBackup) in SQL AlwaysOn Availability Group, then after running Veeam Backup & Replication setup you should do the following:
  1. Manually add the VeeamBackup database to the corresponding SQL AlwaysOn Availability Group.
  2. On the Veeam backup server, in the registry at HKEY_LOCAL_MACHINE\Software\Veeam\Veeam Backup and Replication specify the AlwaysOn Availability Group listener as the SqlServerName value.

in a similar vein, you can deploy Veeam Enterprise Manager database (default name VeeamBackupReporting) in SQL AlwaysOn Availability Group:
  1. Manually add the VeeamBackupReporting database to the corresponding SQL AlwaysOn Availability Group.
  2. On the Enterprise Manager server, in the registry at HKEY_LOCAL_MACHINE\Software\Veeam\Veeam Backup Reporting specify the AlwaysOn Availability Group listener as the SqlServerName value.
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 it's own 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.
KB ID: 2301
Product: Veeam Backup & Replication 10a, Veeam Backup & Replication 9.5, Veeam Backup & Replication 9.0, Veeam Backup & Replication 8.0, Veeam Backup & Replication 7.0
Published: 2017-06-07
Last Modified: 2020-11-20

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.
Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Spelling error in text

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Your report was sent to the responsible team. Our representative will contact you by email you provided.
We're working on it please try again later
Knowledge base content request
By submitting, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Policy.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

ty icon

Thank you!

We have received your request and our team will reach out to you shortly.

OK

error icon

Oops! Something went wrong.

Please go back try again later.