Purging Old Data

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

Purging Old Data

Veeam Logoby dwaksman » Fri Jan 16, 2015 1:58 pm

We received an alert that the "Veeam ONE database size is close to maximum database size supported by SQL Server Express edition." It is running on SQL 2008 R2 Express Edition and is nearning the 10GB maximum. Is there a way to purge old data? I have changed the historical data retention period from 1 year to 6 months,
dwaksman
Novice
 
Posts: 3
Liked: never
Joined: Thu Jan 15, 2015 6:09 pm
Full Name: Dan Waksman

Re: Purging Old Data

Veeam Logoby Shestakov » Fri Jan 16, 2015 3:30 pm

Hello Dan,
How many hosts, VMs are you monitoring?
Shrinking data retention period should help. You can also migrate Veeam One database to SQL Server standard or higher.
Thanks.
Shestakov
Veeam Software
 
Posts: 5015
Liked: 416 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby dwaksman » Fri Jan 16, 2015 3:54 pm

We have 9 hosts and about 120 VMs. Shrinking data retention didn't really do anything. Is there a way to purge old data? We'd prefer to not have to move to SQL Standard.
dwaksman
Novice
 
Posts: 3
Liked: never
Joined: Thu Jan 15, 2015 6:09 pm
Full Name: Dan Waksman

Re: Purging Old Data

Veeam Logoby Shestakov » Fri Jan 16, 2015 4:18 pm

Task to clean database by retention executes once a day in Veeam One Monitor, once a week in Veeam One Reporter. When did you change the retention?
Are you using VMware ESX(i) or Hyper-V visualization?
Thanks.
Shestakov
Veeam Software
 
Posts: 5015
Liked: 416 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby dwaksman » Fri Jan 16, 2015 4:23 pm

I didn't make the change until sometime yesterday afternoon, so that probably explains why the DB hasn't been cleaned yet. We're running VMware.
dwaksman
Novice
 
Posts: 3
Liked: never
Joined: Thu Jan 15, 2015 6:09 pm
Full Name: Dan Waksman

Re: Purging Old Data

Veeam Logoby Shestakov » Fri Jan 16, 2015 4:27 pm

There is an additional concern if you were running Hyper-V, but since you`re on VMware, no worries, let`s just wait for a while and check if the retention change helps.
Please, keep us updated.
Shestakov
Veeam Software
 
Posts: 5015
Liked: 416 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

[MERGED] Veeam ONE 7.0 database size

Veeam Logoby Benedict » Mon Jan 19, 2015 9:41 am

Hello,
I've found today my Veeam ONE server's HDD hasn't any space at all. Seems like SQL databse size has increased too much.
As I know, there is "historical data retention policy" with deafault setting "1 year" existing in Veeam ONE. But I cant found this policy anywhere.
Could you please help me to find it? I want to change it to "6 months" for less database size and better SQL perfomance.
Benedict
Novice
 
Posts: 8
Liked: never
Joined: Mon Jan 19, 2015 9:12 am
Full Name: Dmitriy

Re: Veeam ONE 7.0 database size

Veeam Logoby Vitaliy S. » Mon Jan 19, 2015 9:49 am 1 person likes this post

Hi Dmitriy,

You can change retention policy settings via our support tool.

Here is a way to open it via Monitor GUI (v8 only): http://helpcenter.veeam.com/one/80/vsph ... tings.html

Alternatively, you can navigate to this tool manually:
Code: Select all
C:\Program Files\Common Files\Veeam\Veeam ONE Settings\VeeamOneSettings.exe

Let me know if that helps!
Vitaliy S.
Veeam Software
 
Posts: 19767
Liked: 1120 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE 7.0 database size

Veeam Logoby Benedict » Mon Jan 19, 2015 10:01 am

Vitaliy S. wrote:Hi Dmitriy,

You can change retention policy settings via our support tool.

Here is a way to open it via Monitor GUI (v8 only): http://helpcenter.veeam.com/one/80/vsph ... tings.html

Alternatively, you can navigate to this tool manually:
Code: Select all
C:\Program Files\Common Files\Veeam\Veeam ONE Settings\VeeamOneSettings.exe

Let me know if that helps!

As I said, I have 7.0 version. So there is no Edit button for 4 step @link and no Veeam ONE Settings folder in C:\Program Files\Common Files\Veeam\
Benedict
Novice
 
Posts: 8
Liked: never
Joined: Mon Jan 19, 2015 9:12 am
Full Name: Dmitriy

Re: Purging Old Data

Veeam Logoby Vitaliy S. » Mon Jan 19, 2015 10:03 am

Yes, I saw that you're on version 7, that is why I have given the home path of this tool, which is also applicable to v7 ;) It should be located on your Veeam ONE server (where all services are installed). If you're unable to locate it, our support team would be glad to assist you with this.
Vitaliy S.
Veeam Software
 
Posts: 19767
Liked: 1120 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Purging Old Data

Veeam Logoby Benedict » Mon Jan 19, 2015 10:13 am

Thats my foldertree:

C:/
/Program Files/Veeam/..
/Veeam ONE Business View/..
/Veeam ONE Monitor Server/..
/Veeam ONE Reporter Server/..
/Veeam ONE Reporter Web/..

/Program Files (x86)/Veeam/Veeam ONE/Veeam One Monitor Client/..

Couldnt find any *Settings.exe* files through it.
Benedict
Novice
 
Posts: 8
Liked: never
Joined: Mon Jan 19, 2015 9:12 am
Full Name: Dmitriy

Re: Purging Old Data

Veeam Logoby Vitaliy S. » Mon Jan 19, 2015 10:15 am 1 person likes this post

What about "C:\Program Files\Common Files" on the Veeam ONE machine?
Vitaliy S.
Veeam Software
 
Posts: 19767
Liked: 1120 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Purging Old Data

Veeam Logoby Benedict » Mon Jan 19, 2015 10:44 am

Vitaliy S. wrote:What about "C:\Program Files\Common Files" on the Veeam ONE machine?

Thank you, the problem is solved.
Benedict
Novice
 
Posts: 8
Liked: never
Joined: Mon Jan 19, 2015 9:12 am
Full Name: Dmitriy

[MERGED] : SQL Server Express database size limit

Veeam Logoby nitramz » Wed Feb 04, 2015 2:07 pm

Description
Fired by event: VeeamSqlLowDbFreeSpaceEvent
Event description: Veeam ONE database size is close to its allowed maximum (90.0% is used)
Initiated by: Veeam ONE Monitor (SERVER10)


I'm monitoring only 2 Hyper-V Hosts so i think this database is pretty big.
How can i free up some space? I don't want to switch to SQL Full and i don't need a very long history.

Thanks
nitramz
Lurker
 
Posts: 1
Liked: never
Joined: Wed Feb 04, 2015 2:04 pm
Full Name: Martin Zimmermann

Re: Purging Old Data

Veeam Logoby Shestakov » Wed Feb 04, 2015 2:22 pm

Hello Martin,

There are security events coming from Hyper-V hosts that soil the database. Please contact Veeam technical support for the hot fix.

Thanks.
Shestakov
Veeam Software
 
Posts: 5015
Liked: 416 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Next

Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 12 guests