Restore Veeam Reporter Database

Management reporting and documentation

Restore Veeam Reporter Database

Veeam Logoby Aremac » Wed Oct 08, 2014 6:17 pm

Can Veeam reporter database tables be restored independently of veeam monitor and business view tables?
Aremac
Enthusiast
 
Posts: 57
Liked: 3 times
Joined: Fri Sep 30, 2011 11:59 pm
Full Name: Sam Pierce

Re: Restore Veeam Reporter Database

Veeam Logoby Shestakov » Thu Oct 09, 2014 10:10 am

Hello Sam,

Veeam One use a single database for Monitor, Reporter and Business View.
Out of curiosity why do you need it separately? Thank you.
Shestakov
Veeam Software
 
Posts: 4856
Liked: 394 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Restore Veeam Reporter Database

Veeam Logoby Aremac » Thu Oct 09, 2014 6:38 pm

system crashed in middle of running object cleanup from reporter section of Veeam Once settings. Was concerned about health of database after that occured. I eneded up do a restore of the entire database from previous day. Both before and after the incident reporter is extremely slow. I was attempting to remove old objects from the database which is over 20gb at this point. I may reduce retention to 6mo to see if that helps. Monitor and Business views run fine. But generating a report from reporter often times out or takes 15-20 minutes.
Aremac
Enthusiast
 
Posts: 57
Liked: 3 times
Joined: Fri Sep 30, 2011 11:59 pm
Full Name: Sam Pierce

Re: Restore Veeam Reporter Database

Veeam Logoby Shestakov » Fri Oct 10, 2014 8:52 am

Sam,

So the initial problem is slow operation of Veeam One Reporter.
If you have a big environment(1K+ VMs) it is useful to change data collection interval from 5 minutes(default) to 20 minutes. Or/and to configure SSRS Server Settings.

If it doesn`t help, could you please contact our support team, so we can investigate this behavior closer, since it is to troubleshoot the problem on Community Forums?

Thank you!
Shestakov
Veeam Software
 
Posts: 4856
Liked: 394 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Restore Veeam Reporter Database

Veeam Logoby Vitaliy S. » Sat Oct 11, 2014 6:09 pm

If you restored the database to the previous state, then it shouldn't have any issues, so I agree with Nikita, let our support team have a look what is causing this. As regards the partial restore of the database, then I would not recommend doing that due to tight connection/dependencies between these tables. I'm not sure it will be a supported configuration after that restore operation.
Vitaliy S.
Veeam Software
 
Posts: 19545
Liked: 1099 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Reporting



Who is online

Users browsing this forum: No registered users and 3 guests