Skip to main content
Solved

Space showing Snapshots after deleting snap shots and optimizing DB

  • June 20, 2022
  • 1 reply
  • 226 views

cmoreland
Semi-Pro III
Forum|alt.badge.img

I have removed some snap shots from our production instance and ran the “Optimize Database”  operation. However I am still seeing space being occupied by the snap shots. Has anyone else seen this? How can i keep up with the Whitespace usage and Acumatica. 

 

 

Best answer by hkabiri

@cmoreland Please be informed that snapshots occupying the space are linked to other Tenants which is why do not show on the Tenant screen of selected production tenant.

One way would be do a select query on Company table and find out the records with negative companyid.

You can also do a select query on UPSnapshot table and that shows all the snapshots and their corresponding CompanyID. Then you can login to that tenant based on value of CompanyID and manage them.

 

 

 

View original
Did this topic help you find an answer to your question?

1 reply

hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Support Team
  • 230 replies
  • Answer
  • June 21, 2022

@cmoreland Please be informed that snapshots occupying the space are linked to other Tenants which is why do not show on the Tenant screen of selected production tenant.

One way would be do a select query on Company table and find out the records with negative companyid.

You can also do a select query on UPSnapshot table and that shows all the snapshots and their corresponding CompanyID. Then you can login to that tenant based on value of CompanyID and manage them.

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings