Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V
Post Reply
stewsie
Expert
Posts: 103
Liked: 3 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Veeam One Backup Reporting Database

Post by stewsie » Jan 24, 2019 2:17 pm

Some time ago I arranged to move the Veeam One database from one SQL server to another. I followed the information provided by Veeam but somehow the Veeam Backup Reporting database wasn't moved. The Veeam Reporter Enterprise registry key still points to the original source server even though in the Veeam settings the database specified is the new one.

I need to replace the Veeam One server (not the SQL server) so when I do this is it simply a case of stopping the Veeam One services and then copying the Veeam Backup reporting database to the existing database server where the Veeam One database is already running? Bit confused as to the purpose of the Backup reporting database.

Hope this makes sense to someone

Shestakov
Veeam Software
Posts: 6734
Liked: 680 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Veeam One Backup Reporting Database

Post by Shestakov » Jan 24, 2019 6:15 pm

Hello Paul,
Could you clarify the goal once again? Do you want to replace (migrate) Veeam ONE Server or move Reporting database?
Thanks!

stewsie
Expert
Posts: 103
Liked: 3 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Re: Veeam One Backup Reporting Database

Post by stewsie » Jan 28, 2019 10:08 am

I want to replace the Veeam One server. The database was moved from the Veeam One server some time ago. I have seen the instructions how to replace the Veeam One server and in those notes it mentions checking the registry keys. It is here that I saw reference to the Reporting database still on the original SQL server where the Veeam One database used to reside. Do I need to move this to the SQL server where the Veeam One database resides?

Shestakov
Veeam Software
Posts: 6734
Liked: 680 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Veeam One Backup Reporting Database

Post by Shestakov » Jan 28, 2019 11:35 am 1 person likes this post

Here is KB you need with step-by-step instruction.
Answering your question, it's not necessary to move reporting database as it's part of Veeam ONE database. Check second part of the provided KB article.
Thanks!

stewsie
Expert
Posts: 103
Liked: 3 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Re: Veeam One Backup Reporting Database

Post by stewsie » Jan 30, 2019 2:58 pm

Thanks for the info. I moved the database last year following those instructions and the Veeam One database was migrated. Veeam Backup Reporting database remains in the original location. Should that also have been moved or is that no longer required?

Shestakov
Veeam Software
Posts: 6734
Liked: 680 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Veeam One Backup Reporting Database

Post by Shestakov » Jan 31, 2019 12:01 pm 1 person likes this post

Are you sure it's Veeam ONE Backup Reporting Database, not just Veeam Backup Reporting Database?
Most likely it's a database related to Veeam Backup & Replication, which is independent from Veeam ONE database.
It explains why it didn't move with Veeam ONE database.
Thanks!

Vitaliy S.
Product Manager
Posts: 22687
Liked: 1497 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Backup Reporting Database

Post by Vitaliy S. » Jan 31, 2019 12:13 pm 1 person likes this post

Veeam Backup Reporting database is the database for Veeam Backup Enterprise Manager, so if you need to move this too, then please check out this thread.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests