Monitoring and reporting for Veeam Data Platform
ibeerens
Influencer
Posts: 10
Liked: never
Joined: Jun 16, 2009 8:17 pm
Full Name: Ivo Beerens
Contact:

Re: Purging Old Data

Post by ibeerens »

Is it possible after changing the retension policy to force the cleanup of database?
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Purging Old Data

Post by Shestakov »

There is no way to force it via UI. If you need it desperately, contact support team.
Thanks!
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Purging Old Data

Post by Vitaliy S. »

Out of curiosity, what is the new setting for the retention policy and why have you changed it?
ibeerens
Influencer
Posts: 10
Liked: never
Joined: Jun 16, 2009 8:17 pm
Full Name: Ivo Beerens
Contact:

Re: Purging Old Data

Post by ibeerens »

The new setting is 1 month. We changed that because the SQL Express database has reached the 10 GB limit. The customer is running the free version of Veeam One.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Purging Old Data

Post by Vitaliy S. »

Thanks, and the last one - how many hosts/datastores/VMs does this customer have?
ibeerens
Influencer
Posts: 10
Liked: never
Joined: Jun 16, 2009 8:17 pm
Full Name: Ivo Beerens
Contact:

Re: Purging Old Data

Post by ibeerens »

6 hosts, 170 VMs and 17 datastores
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Purging Old Data

Post by Vitaliy S. »

Perfect, thanks again.
eeye@arteveldehs.be
Lurker
Posts: 2
Liked: never
Joined: Jan 13, 2017 8:18 am
Full Name: Jochen
Contact:

Re: Purging Old Data

Post by eeye@arteveldehs.be »

Since a few weeks i have the same warning in the veeam monitor (8.0.0.1569).
I have changed the retention policy manually from 6 months to one month as described in this article. (C:\Program Files\Common Files\Veeam\Veeam ONE Settings\VeeamOneSettings.exe)
The alert does not clear altough i changed this like 2 weeks ago.
Is there any way to force the cleanup?

kind regards

Jochen
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Purging Old Data

Post by Shestakov »

Hi Jovhen and welcome to the community!
I would repeat this suggestion.
Could you check what is the oldest performance data you have in Veeam ONE Monitor?
Thanks!
eeye@arteveldehs.be
Lurker
Posts: 2
Liked: never
Joined: Jan 13, 2017 8:18 am
Full Name: Jochen
Contact:

Re: Purging Old Data

Post by eeye@arteveldehs.be »

Dear,

I have changed the retention policy and shrunk the DB.
The error is gone now.

Kind regards

Jochen
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Purging Old Data

Post by Shestakov »

Thanks for the recall, Jochen!
By the way, we are planning to automate the process a bit, so you need to wait that long to implement the retention changes.
Rod78
Influencer
Posts: 10
Liked: never
Joined: Aug 28, 2014 6:42 pm
Contact:

Re: Purging Old Data

Post by Rod78 »

Hi, sorry for hijacking but I have this exact problem but with the VeeamBackup database. We are running SQL 2012 Express and upgrading to standard is not an option right now.

VeeamBackup db is 10GB
VeeamBackup_log is 7,5GB

Using SQL Studio Manager shows me the biggest tables
Image

Which tables are ok to purge and how? Or can I just create a new DB and how do I do that correctly? What happens with my backups if I start using a new db?
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Purging Old Data

Post by Shestakov »

Hello Rod78,
Have you tried to shorten retention?
What product version are you at by the way?
Rod78
Influencer
Posts: 10
Liked: never
Joined: Aug 28, 2014 6:42 pm
Contact:

Re: Purging Old Data

Post by Rod78 »

Do you mean retention for VM's as in restore points?
I'm using latest Enterplise plus with Update1
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Purging Old Data

Post by Shestakov »

I meant retention of data you want to keep in the database. You can configure it via support utility.
Thanks!
Rod78
Influencer
Posts: 10
Liked: never
Joined: Aug 28, 2014 6:42 pm
Contact:

Re: Purging Old Data

Post by Rod78 »

Thanks for the link
So this tool also work on VeaamBackup database? On the link they show how to use it on VeeamOne database. I just want to make sure..
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Purging Old Data

Post by Shestakov »

The tool is for Veeam ONE DB only. The topic is on Veeam ONE about VO database. To purge VBR database, please contact Veeam support team.
Thanks!
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Purging Old Data

Post by Shestakov » 1 person likes this post

As SQL Express Maximum Database Size Limitation issue is popular, we created a corresponding KB article.
Post Reply

Who is online

Users browsing this forum: No registered users and 11 guests