Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V
Post Reply
Posts: 1
Liked: 1 time
Joined: Jun 18, 2014 12:56 pm
Full Name: Dave Rowson

Veeam One Retention

Post by daverowson » 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

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


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

Re: Veeam One Retention

Post by Vitaliy S. » 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!

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests