Reduce database size

[NetAdHHRI]

Running Veeam B&R and Veeam ONE on same server, using same SQL express instance. VeeamBackup.mdf is less than 0.5 GB, but I got a message this morning telling me that Veeam ONE is nearing the maximum size supported by SQL express (10GB) - VeeamOne.mdf is 9.2 GB. That seems insane. I'd like to reduce the size of the database, but I don't see anything in the documentation about reducing the amount of data saved. Can someone point me in the right direction?

[RomanK]

Hello Barry,

A retention policy period may be specified for the database not to fill up too fast. You may set the appropriate retention policy period by running the support tool.


The service will schedule a retention policy change for next Saturday night.

It is possible to purge extra data from the database using this script defining the needed datetime parameters
Run it ONLY AT YOU OWN RISK or under Veeam support supervision

Code: Select all

DELETE from monitor.perfsamplelow where timestamp < CONVERT(DATETIME, '2015-01-01 00:00:00.001' ,120)

Thanks

[jorgedlcruz]

Besides what Roman mentioned,
I would go to the Scalability tab on Roman's slide, and change the data collection to Advanced, or even if not VMware real-time required, just keep it as Backup Data only, you can see what you will miss here:
https://helpcenter.veeam.com/docs/one/d ... modes.html

That will definitely help you testing Veeam ONE.

On our System Requirements we recommend using regular SQL, not SQL Express.

I would recommend as well to run the calculator with your data to see more or less an estimator of the sizing:
https://www.veeam.com/kb2246

We are here to help, let us know.

Best regards

[NetAdHHRI]

Thank you both for your help - sorry for the tardy response, I was out of the office for a few days.