How to re-create a database for Enterprise Manager

KB ID: 1109
Products: Veeam Backup & Replication
Version: 6.x, 7.x, 8.x, 9.x
Published:
Last Modified: 2016-10-02

Challenge

Cause

SQL Database for Backup Enterprise Manager is corrupted.

Solution

Please, follow steps below to start with new clean database:

  1. Open registry editor with regedit command on your Enterprise Manager server.
  2. Follow to the path - HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Backup Reporting
  3. Check the SqlDatabaseName parameter and set "value data" to VeeamBackupReporting2 or whatever you like for Enterprise Manager database name (avoid spaces and special symbols).
  4. Restart the services.

User-added image

More Information

  • After deploying the fix, you will start from a blank sheet and will have to re-add your Veeam Backup Servers to Backup Enterprise Manager
  • You will have to synchronize Enterprise Manager with added Veeam Backup servers and allow sync process some time to draw all data back in
  • Old database "VeeamBackupReporting" will still be presented on a SQL server until you manually drop it
4 / 5 (7 votes cast)

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