Restore Large Snapshot

Hi Everyone,

Have you seen such error before when you try to upload snapshot of the size more than a gigabyte?
The Error message: “Snapshot file size exceed the maximum allowed size”.

Acumatica Snapshot Size Limits

There are multiple reasons why it is not allowed – connection stability, IIS limitations, Memory size, on the fly processing limitations and so on.

But what you still need to restore a snapshot and you need to in any possible way? Lucky you there is a stable way for that using Acumatica Configuration Wizard.

Wizard uses the same engine as snapshots to import data during setup, so it can easily insert your snapshots data with no matter on how big is your snapshots as it does not require in memory processing any more.

Lets check how to do it.

  1. First of all get a zip file of a snapshot and extract all files to the folder. I recommend you the same format as other files in Acumatica data folders. In Acumatica 2017 it is XML format.
  2. Put the folder into “C:\Program Files (x86)\Acumatica ERP\Database\Data” folder and make sure that all files are there.
    1. Acumatica Database Data Folder
    2. Acumatica Custom Database Data
  3. Now you can launch Acumatica configuration wizard and it will automatically add your folder to list of data sets it can insert in Acumatica. This data sets are available
    1. Acumatica Custom Database Data
  4. And just complete installation like you install normal demo data.

Your snapshot data will be there as soon as installation is completed.

Hope it helps!

UPDATE 13/07/2018
Unfortunately this approach ignores custom columns data. Even if your snapshot has custom columns (columns with USR prefix), it won’t be inserted during restoration.

UPDATE 20/11/2023
The problem is fixed in 2024r1 version of Acumatica.

15 Replies to “Restore Large Snapshot”

  1. Hi Sergey,

    Are there any updates regarding the custom data part being ignored?
    We are seeing more and more cases with snapshots more than 1 GB.

    1. Hi Yuriy, unfortunately the issue is not fixed yet. I will check with development on the time frame. Thank you for the followup!

  2. Our server crashed.
    We have a large BAK file from backing up MS SQL or full database backup only.
    We do not have a recent snapshot. How can we restore the application with the BAK or MS SQL full back up?

  3. Hi Ahmed,
    Yes it looks like binary format is not supported here anymore.
    The reason for XML is that you can see and edit data without need to restore snapshot first. Basically just easier to use.
    Hope it helps.

  4. Binary format doesn't work for me. Installer detects the folder but is stuck at "Reserving Company IDs."

    Would be great if we could do that as it is the default snapshot format.

    Any reason to do it in XML format?

  5. Hi Sergey,

    If I export in Binary format, will I be able to extract and restore?
    I tried to extract and put the folder and the installer cannot detect folder with *.adb. Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *