Setting up Veeam configuration database in SQL AlwaysOn Availability Group

KB ID: 2301
Product: Veeam Backup & Replication
Version: 6.x, 7.x, 8.x, 9.x
Published:
Last Modified: 2018-03-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.
How helpful is this article: 
5 out of 5 based on 1 ratings

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.

Request new content

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!

Orphus system