by bgalante » Thu Jan 21, 2016 3:17 pm people like this post
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.
by Shestakov » Thu Jan 21, 2016 3:27 pm people like this post
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!