Hello.So my DB has significantly increased in size. I suspect the culprit are orphaned snapshots. I had the warning signed in System → Tenants, that there were at least 2 orphaned snapshots but when I clicked on optimize database to remove does orphaned snapshots I got an error almost immediately and then the warning sign disappeared. Is there a way I can manually check in the SQL database to see if there are any orphaned snapshots and to delete all those records from the database? Also when I check the database size in the Acumatica Interface by going to System - Tenants - View Space Usage, it shows the database size is 110GB in total - but SQL Management Studio shows the Database Size is almost 300GB and when I do a manual backup thats about the size of the .bak file... Any pointers as what I can do to fix this issue would be greatly appreciated.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.