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”.
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.
- 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.
- Put the folder into “C:\Program Files (x86)\Acumatica ERP\Database\Data” folder and make sure that all files are there.
- 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
- 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.
Issue is reported to Acumatica team, I’ll update you as soon as it fixed.
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.
Hi Samvel, i’m sorry but no update still. I will followup internally.
Hi Sergey
Do we have any update on this?
Any update on the fix?
Hi Yuriy, unfortunately the issue is not fixed yet. I will check with development on the time frame. Thank you for the followup!
Any more updates? Fixed or still in progress?
Hi Zaljur, not yet. Please create an idea on https://community.acumatica.com/ and vote for that.
It will help me to justify the ticket priority.
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?
Hi Jonathan,
If you have backup, just restore it with SQL Server Management studio:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-backup-using-ssms?view=sql-server-2017
Hope it helps
Hi Jonathan,
after you restore the .bak file using SSMS. you can proceed with these steps discussed in https://asiablog.acumatica.com/2019/02/restoring-database-and-create-an-instance.html
Hope I can be a help for you
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.
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?
Hi Saiful,
I think it should work with ADB, but I have not tested it that time.
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.
Cool. Thanks Tim.