Monitoring and reporting for Veeam Data Platform
Post Reply
felyjos
Veteran
Posts: 285
Liked: 3 times
Joined: Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN
Contact:

Database Size for VeeamOne?

Post by felyjos »

Hello,

I am getting an issue with the VeeamOne Database:
Message
Could not allocate space for object 'monitor.HistoryTriggAlarm' in database 'VeeamOne' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

I tried to expand the VeeamOne data file but I am getting another error:
Alter failed fro database 'VeeamOne'

Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.

What exactly does this mean?

Thanks,
DOm
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size for VeeamOne?

Post by Vitaliy S. » 1 person likes this post

Hi Dom,
felyjos wrote:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
According to this error message you have exceeded the maximum allowed size for a database in SQL Server Express Edition.

Be aware that SQL Server 2008 R2 Express limits the size of the database by 10 GBs, so to resolve your issue you should either reconfigure Veeam ONE to use a full blown SQL Server or reduce the number of monitored objects.

By the way, how many hosts/VMs and datastores are you currently monitoring with Veeam ONE?

Thanks!
felyjos
Veteran
Posts: 285
Liked: 3 times
Joined: Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN
Contact:

Re: Database Size for VeeamOne?

Post by felyjos »

Data Center: 1
Hosts: 86
VMs: 718
Datastores: 108

Thanks!
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size for VeeamOne?

Post by Vitaliy S. » 1 person likes this post

Well... that explains what's the problem, there are too many objects to fit into the database with 10 GBs max size. Do you have an existing full version of SQL Server to move your Veeam ONE database to?
felyjos
Veteran
Posts: 285
Liked: 3 times
Joined: Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN
Contact:

Re: Database Size for VeeamOne?

Post by felyjos »

Yes i have a Full Version of SQL Server 2008 Enterprise I could use. But if the database needs to grow a lot I would like to move it to the SQL Cluster already in place and previously used for Veeam reporter... is it something viable?

Thanks,
Dom
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size for VeeamOne?

Post by Vitaliy S. » 1 person likes this post

Yes, why not ;)

If you decide to migrate Veeam ONE database to a new SQL Server, please look through this KB article that describes how to reconfigure Veeam ONE after moving its database to a new server: http://www.veeam.com/kb_articles.html/KB1599/

Thanks!
felyjos
Veteran
Posts: 285
Liked: 3 times
Joined: Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN
Contact:

Re: Database Size for VeeamOne?

Post by felyjos »

Hello,
I have SQL Server 2008 R2 installed 10.50.1600.1 and VeeamOne database is still refusing to go over the 10 Gb limit of the SQL Server 2008 eXpress any explanation?
ERROR.log
2012-09-18 17:13:42.86 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Select @@version
(No column name)
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

Thanks,
DOm
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size for VeeamOne?

Post by Vitaliy S. » 1 person likes this post

Hello Dom,

What edition of SQL Server 2008 R2 are you using to host Veeam ONE database? Based on the error message above, I can see that you're using "Microsoft SQL Server 2008 R2 Express Edition with Advanced Services", which explains why your database cannot grow over 10 GBs of max database size.

To resolve that you should be using either a full blown SQL Server Edition or change the number of objects being monitored.

Thank you!
Zarra
Novice
Posts: 4
Liked: never
Joined: Oct 04, 2012 8:57 am
Contact:

[MERGED] Veeam One Free Edition Collection Job Fail

Post by Zarra »

Hello, this is my first post.
I am using the Veeam one free edition but the last days the task collection job finish with fail state.
In the file schedulingservice.log i see the following errors:

Exception Source: .Net SqlClient Data Provider
Exception Type: System.Data.SqlClient.SqlException
Exception Message: Could not allocate space for object 'reporter.ObjectProperty'.'IDX_ModificationID' in database 'VeeamOne' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Exception Target Site: OnError


Exception Source: .Net SqlClient Data Provider
Exception Type: System.Data.SqlClient.SqlException
Exception Message: Could not allocate a new page for database 'VeeamOne' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
The statement has been terminated.
Exception Target Site: OnError

Is a problem with the Sql 2005 Express but i have checked that the database have enabled "enable autogrowth".
Is there a solution to this problem?

Note: I don't have license to mount an instance of Sql 2005 Full. I'm monitoring one VC with seven hosts esx and a total of 219 VM.

Many thanks.

Zarra.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size for VeeamOne?

Post by Vitaliy S. » 1 person likes this post

Hello Zarra,

SQL Server 2005 Express edition has a limitation for the maximum size of the database. As far as I remember you can only grow up to 4 GBs and it looks like you've already reached this limit. If you do not have full SQL Server licenses, then I would recommend to migrate to SQL Server 2008R2 Express edition. This edition allows having databases of 10 GBs size, which should be enough for your environment.

P.S. Our support team can assist you with the migration process, you just need to log a support case on that.

Thank you!
Zarra
Novice
Posts: 4
Liked: never
Joined: Oct 04, 2012 8:57 am
Contact:

Re: Database Size for VeeamOne?

Post by Zarra »

Ok, I will try to install SQL Server 2008R2 Express edition, is valid this KB (http://www.veeam.com/kb_articles.html/KB1599/) for the migration?
I'll tell you the results.

Thank you very much.

Zarra.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size for VeeamOne?

Post by Vitaliy S. » 1 person likes this post

Yes, it is (if you're running Veeam ONE v6)!
chillware
Influencer
Posts: 23
Liked: 1 time
Joined: Apr 07, 2011 4:38 pm
Full Name: David McCoy
Contact:

Re: Database Size for VeeamOne?

Post by chillware »

Is there a sql command to truncate old data from the db? I am up against the 10gb limit in sql express, I don't want to move the DB.. I'd prefer to truncate data say 6 months and older, how can I do that?

Thanks!
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size for VeeamOne?

Post by Vitaliy S. » 1 person likes this post

Hi David,

We've got a support utility that can be used to change data retention policy, please contact our technical team for further instructions.

Thanks!
Zarra
Novice
Posts: 4
Liked: never
Joined: Oct 04, 2012 8:57 am
Contact:

Re: Database Size for VeeamOne?

Post by Zarra »

Vitaliy S. wrote:Hi David,

We've got a support utility that can be used to change data retention policy, please contact our technical team for further instructions.

Thanks!
Hi, I need this utility or how can i truncate my veeam one database, the database is full and veeam one is out of order.

Thanks in advance.

Zarra.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size for VeeamOne?

Post by Vitaliy S. »

Please find this tool in this folder:

Code: Select all

C:\Program Files\Common Files\Veeam\Veeam ONE Settings\VeeamOneSettings.exe
Zarra
Novice
Posts: 4
Liked: never
Joined: Oct 04, 2012 8:57 am
Contact:

Re: Database Size for VeeamOne?

Post by Zarra »

ok, thanks.
Balazs_Berczi
Lurker
Posts: 1
Liked: never
Joined: Mar 08, 2017 9:33 am
Full Name: Balazs Berczi
Contact:

Re: Database Size for VeeamOne?

Post by Balazs_Berczi »

Hi

We have the same problem with reporter.ObjectProperty table. It is 7.3 GB.

Vitaliy or Zarra: could you please share this Utility with me?

Thank you very much!
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size for VeeamOne?

Post by Vitaliy S. »

Balazs,

If you refer to the utility that can adjust the retention policy, then you can find it in the Veeam ONE installation folder (see my post above) or just use these guidelines > Veeam ONE Settings Utility

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

Re: Database Size for VeeamOne?

Post by Shestakov »

Veeam ONE database calculator is now updated for v9.5
You may set your infrastructure size and basic settings and check your DB size against the calculator.
Let us know your feedback!
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests