Purging Old Data

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

Re: Purging Old Data

Veeam Logoby ibeerens » Tue Oct 11, 2016 10:19 am

Is it possible after changing the retension policy to force the cleanup of database?
ibeerens
Novice
 
Posts: 8
Liked: never
Joined: Tue Jun 16, 2009 8:17 pm
Full Name: Ivo Beerens

Re: Purging Old Data

Veeam Logoby Shestakov » Tue Oct 11, 2016 10:58 am

There is no way to force it via UI. If you need it desperately, contact support team.
Thanks!
Shestakov
Veeam Software
 
Posts: 4842
Liked: 393 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby Vitaliy S. » Tue Oct 11, 2016 11:15 am

Out of curiosity, what is the new setting for the retention policy and why have you changed it?
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Purging Old Data

Veeam Logoby ibeerens » Tue Oct 11, 2016 11:33 am

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.
ibeerens
Novice
 
Posts: 8
Liked: never
Joined: Tue Jun 16, 2009 8:17 pm
Full Name: Ivo Beerens

Re: Purging Old Data

Veeam Logoby Vitaliy S. » Tue Oct 11, 2016 11:34 am

Thanks, and the last one - how many hosts/datastores/VMs does this customer have?
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Purging Old Data

Veeam Logoby ibeerens » Tue Oct 11, 2016 11:41 am

6 hosts, 170 VMs and 17 datastores
ibeerens
Novice
 
Posts: 8
Liked: never
Joined: Tue Jun 16, 2009 8:17 pm
Full Name: Ivo Beerens

Re: Purging Old Data

Veeam Logoby Vitaliy S. » Tue Oct 11, 2016 11:48 am

Perfect, thanks again.
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Purging Old Data

Veeam Logoby eeye@arteveldehs.be » Fri Jan 13, 2017 8:41 am

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
eeye@arteveldehs.be
Lurker
 
Posts: 2
Liked: never
Joined: Fri Jan 13, 2017 8:18 am
Full Name: Jochen

Re: Purging Old Data

Veeam Logoby Shestakov » Fri Jan 13, 2017 10:07 am

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!
Shestakov
Veeam Software
 
Posts: 4842
Liked: 393 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby eeye@arteveldehs.be » Tue Jan 17, 2017 12:39 pm

Dear,

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

Kind regards

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

Re: Purging Old Data

Veeam Logoby Shestakov » Tue Jan 17, 2017 12:49 pm

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.
Shestakov
Veeam Software
 
Posts: 4842
Liked: 393 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby Rod78 » Tue Apr 25, 2017 8:36 am

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?
Rod78
Influencer
 
Posts: 10
Liked: never
Joined: Thu Aug 28, 2014 6:42 pm

Re: Purging Old Data

Veeam Logoby Shestakov » Wed Apr 26, 2017 11:45 am

Hello Rod78,
Have you tried to shorten retention?
What product version are you at by the way?
Shestakov
Veeam Software
 
Posts: 4842
Liked: 393 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby Rod78 » Wed Apr 26, 2017 11:50 am

Do you mean retention for VM's as in restore points?
I'm using latest Enterplise plus with Update1
Rod78
Influencer
 
Posts: 10
Liked: never
Joined: Thu Aug 28, 2014 6:42 pm

Re: Purging Old Data

Veeam Logoby Shestakov » Wed Apr 26, 2017 12:09 pm

I meant retention of data you want to keep in the database. You can configure it via support utility.
Thanks!
Shestakov
Veeam Software
 
Posts: 4842
Liked: 393 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

PreviousNext

Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 3 guests