Veeam ONE Database size becomming large

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

Re: Veeam ONE Database size becomming large

Veeam Logoby Shestakov » Tue Jan 19, 2016 2:10 pm

Not at once. Task to clean database by retention executes once a day in Veeam One Monitor, once a week in Veeam One Reporter.
Shestakov
Veeam Software
 
Posts: 5023
Liked: 418 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

[MERGED] MDF

Veeam Logoby risingflight » Thu Jan 21, 2016 2:34 am

Hi Everyone,

I am using SQL 2008 R2, When i look at the db file, the size is 250 GB, please guide me how to reduce the size.

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\mydb.MDF

MYDB.MDF file size is 250 GB and i am running out of disk size. experts help me.

In the veeam application it is 6 months logs but i dont think it is 6 months may be for more than 2 years.
risingflight
Influencer
 
Posts: 23
Liked: never
Joined: Sun Nov 29, 2015 6:04 pm
Full Name: RisingFlight

Re: Veeam ONE Database size becomming large

Veeam Logoby Shestakov » Thu Jan 21, 2016 9:22 am

Hi RisingFlight,
How many hosts, vms, datastores do you have?
risingflight wrote:In the veeam application it is 6 months logs but i dont think it is 6 months may be for more than 2 years.

Do you mean historical performance, events data?
Thanks!
Shestakov
Veeam Software
 
Posts: 5023
Liked: 418 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Veeam ONE Database size becomming large

Veeam Logoby Vitaliy S. » Thu Jan 21, 2016 10:38 am

What platform are you at? VMware or Hyper-V?
Vitaliy S.
Veeam Software
 
Posts: 19770
Liked: 1120 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE Database size becomming large

Veeam Logoby bgalante » Thu Jan 21, 2016 3:17 pm

Hi,

I'm back with the results of my original issue.

I reduced the retention period in Veeam ONE from 12 months to 3 On Tuesday.
I waited until today (2 days) to check if the daily "clean up" job had reduced the size of the DB. Is has not, it was actually 2 GB larger that when i started this thread last week.
I want to clarify, the DB is on a different host from the Veeam ONE application.

My DBA ran a "shrink" on the DB and was able to reduce it from 62GB to 60. I thought I'd see a greater reduction seeing I reduced the retention period by 75%.

Does something need to be run on the SQL Server hosting the DB?

Is there a log, or something that shows if the cleanup job ran, and the details of what it cleaned up? I wasn't able to locate it.
bgalante
Enthusiast
 
Posts: 35
Liked: 1 time
Joined: Mon Jul 27, 2015 5:14 pm
Full Name: Brian Galante

Re: Veeam ONE Database size becomming large

Veeam Logoby Shestakov » Thu Jan 21, 2016 3:27 pm

Hi Brian, yes the data retention changes should be tracked in the Veeam ONE log. As was stated before Veeam One Reporter renews retention once a week so I would wait for several more days.
However if you decide to review the logs, you can contact Veeam technical support team for an assistance.
Thanks!
Shestakov
Veeam Software
 
Posts: 5023
Liked: 418 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Veeam ONE Database size becomming large

Veeam Logoby Vitaliy S. » Thu Jan 21, 2016 4:24 pm

To the best of my knowledge most data is consumed by performance data, so I would definitely open a support case to confirm that monitoring data has been cleaned up.
Vitaliy S.
Veeam Software
 
Posts: 19770
Liked: 1120 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE Database size becomming large

Veeam Logoby Reklov » Tue Nov 01, 2016 8:53 am

..."will that automatically purge the old data or is there an additional step? "
well, that would also be interesting for me

Thanks.
Reklov
Enthusiast
 
Posts: 42
Liked: 1 time
Joined: Thu Aug 28, 2014 12:16 pm

Re: Veeam ONE Database size becomming large

Veeam Logoby Shestakov » Tue Nov 01, 2016 9:09 am

Hi Reklov,
as was answered previously: "Not at once. Task to clean database by retention executes once a day in Veeam One Monitor, once a week in Veeam One Reporter."
Shestakov
Veeam Software
 
Posts: 5023
Liked: 418 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Previous

Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 3 guests