Skip to main content
Answer

Feeling Stuck on Making a Sandbox of our Database

  • August 22, 2025
  • 5 replies
  • 86 views
L
Freshman II
Forum|alt.badge.img

Hi all! Hope your day is going well!

It's finally the slow season at my company and I wanna jump into the long list of customization projects that have been put on hold. There's only one issue: 

I can't get our information into any of the DB's I create through the Acumatica ERP Configuration Wizard due to the Snapshot being 6GB and the limit of 1.5 for restoring snapshots in the created DB. 

I found this post from four years ago: https://community.acumatica.com/configuration-and-installation-114/import-snapshot-into-test-environment-6303?postid=128322#post128322

But I don't understand how I would Backup the DB and the Restore it this way due to not being familiar with those processes listed.  

Could someone help with a more dumbed down version of how to get my Company's data into a sandbox instance? I don't care what method so long as i

Best answer by jhouser

Hi ​@lunarchickadee Have you tried taking a snapshot without attachments and wikis? This makes the snapshot considerably smaller. 

Regarding DB backup method, is your instance cloud hosted by Acumatica? If yes, you would need to request a backup from Acumatica, and I believe there's a fee. 

    robk20

    5 replies

    jhouser
    Captain II
    Forum|alt.badge.img+6
    • jhouser
    • Captain II
    • Answer
    • August 22, 2025

    Hi ​@lunarchickadee Have you tried taking a snapshot without attachments and wikis? This makes the snapshot considerably smaller. 

    Regarding DB backup method, is your instance cloud hosted by Acumatica? If yes, you would need to request a backup from Acumatica, and I believe there's a fee. 

    Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
    Chris Hackett
    JSpikowski
    Jr Varsity II
    Forum|alt.badge.img
    • JSpikowski
    • Jr Varsity II
    • August 22, 2025

    "If yes, you would need to request a backup from Acumatica, and I believe there's a fee."

    Another good reason to host your own DB server. Having direct access to your DB and doing external REST interfaces to other sources (e-commerce, custom apps,...) and writing to custom tables in your Acumatica tenant DB relieves the customization effort in Acumatica.

     

    Chris Hackett
    L
    Freshman II
    Forum|alt.badge.img
    • lunarchickadee
    • Author
    • Freshman II
    • August 22, 2025

    ​@jhouser I haven’t yet, but that’s a solid point on the smaller snapshot. I could probably run one this weekend and see

    And yeah, I think we’re hosted with Acumatica. Does anyone happen to know the fee? 

    jhouser
    Captain II
    Forum|alt.badge.img+6
    • jhouser
    • Captain II
    • August 22, 2025

    ​@lunarchickadee Regarding the fee, I would check with your VAR. 

    Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
    Chris Hackett
    rcreasy
    rcreasy
    Varsity I
    Forum|alt.badge.img
    • rcreasy
    • Varsity I
    • August 25, 2025

    ​@lunarchickadee Regarding the fee, I would check with your VAR. 

    It is worth asking the cost of an ongoing backup. e.g. daily to an sFTP location you can access anytime. 
    Cost will depend on your plan

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved