Manage / Reduce Database Size - Everything Else https://www.augforums.com/forums/everything-else/manage-reduce-database-size/ Acumatica User Group Forums en-US Thu, 21 May 2026 10:32:20 +0000 wpForo 60 RE: Manage / Reduce Database Size https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-11475 Thu, 10 Oct 2024 15:43:48 +0000 Everything Else jwaldron https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-11475 RE: Manage / Reduce Database Size https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-11474 Wed, 09 Oct 2024 22:43:41 +0000 Yes, please!  This is a nagging concern.  Thank you!

]]> Everything Else Debbie Reed https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-11474 RE: Manage / Reduce Database Size https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-11471 Tue, 08 Oct 2024 16:26:42 +0000 It's been a moment. Any news on a clean way to kill off emails, files, and audit history? Below is my space usage sorted by table size. Any guidance for any of those top 3 tables would be appreciated.

3566

 

My understanding is that:

  • UploadFileRevision is our attachments and upload revisions
    • I have seen some SQL solutions, but would love to avoid executing something so vast
  • AuditHistory is our log of changes on tables we've enabled
    • I tried using Security Preferences, it seems to do nothing
  • AUNotificationTemplate is every email we've ever sent (since 2017)
    • I tried both archiving and deleting, seems neither of those actualy shrink/reduce data
]]> Everything Else MichaelHansen https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-11471 RE: Manage / Reduce Database Size https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-10952 Sat, 21 Oct 2023 00:09:48 +0000 @jwaldron Since you have Acumatica reading the emails from that email address, it has to store them somewhere. You could probably do a database script to find emails that aren't attached to an Activity and then delete them.

 

You might want to try AugSQL (click here), which allows you to run SQL code and see the results immediately on the screen, even if you're in an Acumatica SaaS Instance. You can also use AugSQL to run SQL code on a schedule so you could have it run nightly to cleanup emails that aren't attached to an Activity.

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-10952 RE: Manage / Reduce Database Size https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-10488 Tue, 07 Feb 2023 20:07:46 +0000 Has this ever been solved with newer versions?  We just added a user inbox as a system email account as a suggestion by Acumatica, and it jumped by database size from 80 to 95 GB.  We've used Acumatica for 6 years and attach a lot of PDF scanned documents to our transactions.  But having so many regular emails not attached to an Acumatica transaction is not practical.  It should only keep emails that are tied to an activity, right?  Why is it keeping a record of every email?

]]> Everything Else jwaldron https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-10488 RE: Manage / Reduce Database Size https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-6117 Sun, 01 Mar 2020 07:52:11 +0000 Good move having Acumatica do the purge. Make them earn their SaaS fee :)

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-6117 RE: Manage / Reduce Database Size https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-5994 Tue, 11 Feb 2020 18:10:19 +0000 We are having Acumatica purge for use through a case.  We have 17GB of e-mails that we don't need in Acumatica and deleting wasn't going to help since they would still be in the database.  

]]> Everything Else Bryan Bresnan https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-5994 RE: Manage / Reduce Database Size https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-5203 Thu, 26 Sep 2019 14:19:22 +0000 @gabriel-michaud

I agree the snapshots are double edge swords, it's so easy but it can bloat your database size, and if your snapshot size is over 1GB (not DB) you won't be able to take snapshots due to IIS constraints from what support mentioned ...
The other culprit is audit history/SQL profile log  if you turn it on and forget to purge or clean then it will be heavy, third is file storage.
If you allow customers to upload art files then they will blow through the space usage, suggesting them to use AWS/local folder structure is good.

I can't vouch for 1 TB database, it's all relative to resource level, how they store data/files and transaction volume and how you optimize within that space :)

]]> Everything Else Harsha Sarjapur https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-5203 RE: Manage / Reduce Database Size https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-5201 Thu, 26 Sep 2019 14:04:24 +0000 In my experience in many cases the high database size is due to an overabundance of snapshots or log tables. In the past automation schedule history was the main culprit but in recent versions they added a setting to control the number of executions to keep in the log. PushNotificationErrors is another table that could be purged easily -- you if you don't have direct SQL access you can create a dummy customization project and run a TRUNCATE TABLE script to clean it during publishing. In the example above this table accounts for 50% of the total size of the tenant!

I'd be curious to hear what are the largest database sizes you've seen with Acumatica - one of the companies I work with has a 1tb database!

]]> Everything Else Gabriel Michaud https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-5201 RE: Manage / Reduce Database Size https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-5200 Thu, 26 Sep 2019 13:43:28 +0000 I'd love to see them offer something like a "cold" storage option where you "purge" the data out of the Acumatica database, but into a blob in AWS (especially GL data). Blob storage is so cheap in AWS. And it can still be reported on with BI tools. Maybe even Velixo reports in the future.

Would love to hear thoughts from @gabriel-michaud1 on this.

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/manage-reduce-database-size/#post-5200