Veeam One Retention

Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V

Veeam One Retention

Veeam Logoby daverowson » Wed Jun 18, 2014 1:07 pm 1 person likes this post

Dear Forum

I would like to raise the following issue, not a fault, but will more than likely impact many users.

veeam one monitor, version 7.0.0.876

We are an extensive Veeam backup and replication user, together with the Veeam one monitoring product, and have been for many years.

Our Veeam one monitoring runs on the shipped sql 2008 express database, and constantly runs out of space, monitoring out 130 vm’s.

I am not interested in historical data longer than 1 month, however the only options for retention are 6 months, 1 year upwards, and as a result the database fills up quickly.

When raised with support under Case # 00523336 we are told that there is no way to reduce it, other than run a script to clear the database!

script offered:
You can remove all data by using the following script.

PLEASE, back up the Veeam One database before you proceed past this line.

Truncate table monitor.PerfSampleMed
Truncate table monitor.PerfSampleLow
Update monitor.VwCollectorConfig set last_perf_rt_poll_time = null

Veeam One will then pull available data from the VC and you will have the VO database consistent with what is in the VC database.

I have created a sql batch file that clears the data out each month, but surely there is a better solution?

Is this something that your aware of, or planning to offer an alternative in the future?

Thank you

Dave
daverowson
Lurker
 
Posts: 1
Liked: 1 time
Joined: Wed Jun 18, 2014 12:56 pm
Full Name: Dave Rowson

Re: Veeam One Retention

Veeam Logoby Vitaliy S. » Wed Jun 18, 2014 3:40 pm 1 person likes this post

Hello Dave,

Yes, we are planning to give more flexibility in retention policy settings in the next major release. Meanwhile, you may want to change retention policy settings via this script:
Code: Select all
update common.ServerSettings set RetentionPolicyPeriod = %MONTHS%

P.S. be aware that Veeam ONE utility will still show 6 month, as that's the lowest value we currently have for the UI. Once you apply this script, the retention policy will wipe out all data that is older than specified number of the months.

Thank you!
Vitaliy S.
Veeam Software
 
Posts: 19575
Liked: 1106 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 4 guests