Monitoring and reporting for Veeam Data Platform
dwaksman
Novice
Posts: 3
Liked: never
Joined: Jan 15, 2015 6:09 pm
Full Name: Dan Waksman
Contact:

Purging Old Data

Post by dwaksman »

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,
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 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.
dwaksman
Novice
Posts: 3
Liked: never
Joined: Jan 15, 2015 6:09 pm
Full Name: Dan Waksman
Contact:

Re: Purging Old Data

Post by dwaksman »

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.
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 »

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.
dwaksman
Novice
Posts: 3
Liked: never
Joined: Jan 15, 2015 6:09 pm
Full Name: Dan Waksman
Contact:

Re: Purging Old Data

Post by dwaksman »

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.
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 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.
Benedict
Novice
Posts: 8
Liked: never
Joined: Jan 19, 2015 9:12 am
Full Name: Dmitriy
Contact:

[MERGED] Veeam ONE 7.0 database size

Post by Benedict »

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.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam ONE 7.0 database size

Post by Vitaliy S. » 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!
Benedict
Novice
Posts: 8
Liked: never
Joined: Jan 19, 2015 9:12 am
Full Name: Dmitriy
Contact:

Re: Veeam ONE 7.0 database size

Post by Benedict »

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\
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. »

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.
Benedict
Novice
Posts: 8
Liked: never
Joined: Jan 19, 2015 9:12 am
Full Name: Dmitriy
Contact:

Re: Purging Old Data

Post by Benedict »

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.
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. » 1 person likes this post

What about "C:\Program Files\Common Files" on the Veeam ONE machine?
Benedict
Novice
Posts: 8
Liked: never
Joined: Jan 19, 2015 9:12 am
Full Name: Dmitriy
Contact:

Re: Purging Old Data

Post by Benedict »

Vitaliy S. wrote:What about "C:\Program Files\Common Files" on the Veeam ONE machine?
Thank you, the problem is solved.
nitramz
Novice
Posts: 3
Liked: 1 time
Joined: Feb 04, 2015 2:04 pm
Full Name: Martin Zimmermann
Contact:

[MERGED] : SQL Server Express database size limit

Post by nitramz »

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
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 Martin,

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

Thanks.
squirrel

Re: Purging Old Data

Post by squirrel »

Shestakov wrote: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.
What does that mean exactly? I'm monitoring Hyper-V hosts (no VMware yet), so is there a bug that I need to have a hotfix for fixing "junk events" in the Veeam ONE database?

I just discovered that my database is out of space (at 10 GB limit because of SQL 2008 R2 Express), so I need to clear up some space. I'm wondering if the Hyper-V security events filled up my 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 »

Hello,
Yes, there was a Hyper-V issue of flooded Veeam ONE database with events from the Windows security log.
It has been fixed in the Veeam ONE 8 Patch 1. Please review and install.
Thanks.
squirrel

Re: Purging Old Data

Post by squirrel »

Shestakov wrote:Hello,
Yes, there was a Hyper-V issue of flooded Veeam ONE database with events from the Windows security log.
It has been fixed in the Veeam ONE 8 Patch 1. Please review and install.
Thanks.
How do I clear out the trash from the Windows security log that got put in my Veeam ONE database then?
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. »

You can ask our support team for assistance with this, they should have a script for that.
JonM1
Novice
Posts: 7
Liked: never
Joined: Mar 03, 2014 4:05 pm
Full Name: Jon Murray
Contact:

[MERGED] Purge old data from Veeam ONE database

Post by JonM1 »

Hi

Using SQL Express DB for Veeam ONE v8 and it's almost full I think - getting warnings about DB size. Although i've reduced the retention policy the DB size hasn't gone down. I've seen similar posts about people trying the same thing and the DB size staying the same, so is there a way to manually purge the old data? I know we can move the DB to SQL Server but don't wish to do this.

Thanks
Jon
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 Jon,

Shrinking retention period is the easiest way. As was mentioned in the thread above, the task to clean database by retention executes once a day in Veeam One Monitor, once a week in Veeam One Reporter. Probably, you just need to wait for a while.

When did you change the retention? What version are you at? Are you using VMware ESX(i) or Hyper-V visualization? 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. »

Also can you please tell us how many hosts/VMs and datastores you're monitoring?
JonM1
Novice
Posts: 7
Liked: never
Joined: Mar 03, 2014 4:05 pm
Full Name: Jon Murray
Contact:

Re: Purging Old Data

Post by JonM1 »

Hi,

I reduced the retention period well over a week ago now, so I would have expected it to go down by now if that method was going to work.

Using version 8.0.0.1669 with VMware. 7 hosts, 36 datastores and approx 157 VMs.

VeeamONE DB says 9.99GB

Thanks
Jon
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 Jon and thanks for updating.
JonM1 wrote:Although i've reduced the retention policy the DB size hasn't gone down.
Could you specify the retention policy changes you made? Thanks!
JonM1
Novice
Posts: 7
Liked: never
Joined: Mar 03, 2014 4:05 pm
Full Name: Jon Murray
Contact:

Re: Purging Old Data

Post by JonM1 »

Hi,

I reduced it from 12 months down to 6 months.

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 »

Could you check what is the oldest performance data you have? The easy way is to check some performance metrics in the Monitor choosing "last year" period. So we will see if the older data is gone.
If you have 6 months of data or less, you need either to migrate Veeam One database to SQL Server standard(or higher) or change periodicity of the collection. Thanks!
JonM1
Novice
Posts: 7
Liked: never
Joined: Mar 03, 2014 4:05 pm
Full Name: Jon Murray
Contact:

Re: Purging Old Data

Post by JonM1 »

OK, it goes back to January this year so looks like the data isn't there anymore, although the DB hasn't shrunk in size to reflect that? Would that not be expected?

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 »

Great, the older data has been cleaned, in according to the preset retention. Have you checked what was the oldest data before you changed the retention?
Probably, size of the remaining data is still 10GB and nevertheless you changed the retention you`ve already reached the SQL Express DB maximum.

To be 100% sure if Veeam One works correctly, I would change the retention from 6 to 4 months (or 5 if you didn`t add new object to monitor in the last 6 months), wait for a week to see if the size will be shrunk. If yes, 6 months is the limit for your current infrastructure and DB. If it`s still 10GB, it`s better to contact Veeam support for the issue investigation. 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. »

If you shrink it with a SQL Management Studio, do you see the change of the database size?
JonM1
Novice
Posts: 7
Liked: never
Joined: Mar 03, 2014 4:05 pm
Full Name: Jon Murray
Contact:

Re: Purging Old Data

Post by JonM1 »

OK so I shrunk it with SSMS and it went down to 9.22GB :/

I will change it from 6 months to 5/4 months and wait and see if it goes down further or I can shrink it some more. If not, then it will need to be migrated I guess.

Thanks for the help
Post Reply

Who is online

Users browsing this forum: No registered users and 12 guests