Purging Old Data

[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]

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]

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]

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]

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]

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]

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

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]

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

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]

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

What about "C:\Program Files\Common Files" on the Veeam ONE machine?

[Benedict]

What about "C:\Program Files\Common Files" on the Veeam ONE machine?

Thank you, the problem is solved.

[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]

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]

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]

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]

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

You can ask our support team for assistance with this, they should have a script for that.

[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]

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

Also can you please tell us how many hosts/VMs and datastores you're monitoring?

[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]

Hi Jon and thanks for updating.

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]

Hi,

I reduced it from 12 months down to 6 months.

Thanks

[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]

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]

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

If you shrink it with a SQL Management Studio, do you see the change of the database size?

[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