alternative database

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

alternative database

Veeam Logoby cmaier » Mon Feb 24, 2014 4:09 pm

Hi,

our SQL Express runs out of space. Can I run Veeam One on a non-Microsoft database? We have a large Oracle installation here for instance.

Best regards
Christian
cmaier
Influencer
 
Posts: 23
Liked: 1 time
Joined: Mon Feb 24, 2014 4:01 pm
Full Name: Christian Maier

Re: alternative database

Veeam Logoby Vitaliy S. » Mon Feb 24, 2014 4:37 pm

Hi Christian,

Veeam ONE supports MS SQL Server only. In order to lower the size of the database you can adjust retention policy settings via support utility >
Code: Select all
C:\Program Files\Common Files\Veeam\Veeam ONE Settings\VeeamOneSettings.exe

BTW, how many hosts/VMs/datastores are you monitoring with Veeam ONE?

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: alternative database

Veeam Logoby cmaier » Tue Feb 25, 2014 7:12 am

Hi Vitaly,

the retention policy is already set to the minimum of 6 months. I would be happy with 3 months, too. But this is not choosable. We monitor 6 hosts, 96 VMs and 107 datastores. I don't know if this is too much.

What we don't use at the moment is the business view. Is it possible to disable it completely and get it out of the database?
cmaier
Influencer
 
Posts: 23
Liked: 1 time
Joined: Mon Feb 24, 2014 4:01 pm
Full Name: Christian Maier

Re: alternative database

Veeam Logoby Vitaliy S. » Tue Feb 25, 2014 8:02 am

VM performance data is the main contributor to Veeam ONE database size, so removing any configuration data will not do the trick. Do you use SQL Server Express 2008 or above?
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: alternative database

Veeam Logoby cmaier » Tue Feb 25, 2014 12:10 pm

Yes, the 2008 R2 that Veeam delivers.
cmaier
Influencer
 
Posts: 23
Liked: 1 time
Joined: Mon Feb 24, 2014 4:01 pm
Full Name: Christian Maier

Re: alternative database

Veeam Logoby Vitaliy S. » Tue Feb 25, 2014 12:36 pm

Hmm...ok, I have just thought that you might be using SQL Server 2005 that has a 4GB limit for the database size.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: alternative database

Veeam Logoby cmaier » Tue Feb 25, 2014 12:46 pm

The strange thing is that I changed the retention policy from 1 year to 6 months. This was about 2 months ago and the database is full again? Is it possible to purge old data manually?
cmaier
Influencer
 
Posts: 23
Liked: 1 time
Joined: Mon Feb 24, 2014 4:01 pm
Full Name: Christian Maier

Re: alternative database

Veeam Logoby Vitaliy S. » Tue Feb 25, 2014 12:50 pm

Old data is purged automatically according to the configured retention policy. If the configured threshold does not give the result you need, I believe there might be a way to remove historical performance data manually. Please contact our technical team for assistance with this.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: alternative database

Veeam Logoby cmaier » Tue Feb 25, 2014 12:56 pm

Ok, thank you.
cmaier
Influencer
 
Posts: 23
Liked: 1 time
Joined: Mon Feb 24, 2014 4:01 pm
Full Name: Christian Maier


Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 4 guests