Database retention policies don't work
Hi!
We configured database retention to delete logs older than 1 year, but the logs still stay in the database. It has been like this through multiple DVLS updates with no change. We are currently on 2026.1.24.0. For some tables, we have entries from 2019.
I have not clicked "Clean up now" yet, because I want to verify it works automatically.
I checked some of the "_Archive" tables, and none of them contain any entries.
Scheduler service is installed and running. Automatic backups work.
How to troubleshoot further?
Thank you!
Best regards, Daniel
All Comments (30)
Hello,
Could you please verify in the server logs in DVLS to see if you might have some logs related to the failure of the cleanup?
The scheduler might be unable to delete or archive the logs because there might be too many for the first run.
Would it be possible to run a Disk usage by top table report in SSMS and share it with us through email at service@devolutions.net?
Best regards,