Importing a snapshot: The file is not found or you don't have enough rights to see the file
When I want to import a snapshot, I get an error: " The file is not found or you don't have enough rights to see the file". The file is definitely found. and I am signed in as an administrator. In github, MikeNike had the same experience: https://stackoverflow.com/questions/49365538/upload-of-large-company-snapshot-results-in-error-the-file-exceeds-the-maximal/59619917#59619917 Go to the bottom of the page, and you will see that he had a DB table with a blob that was not compressed. I don't know how he solved it.
The file was large then 1GB. I updated web.config for 2GB. I could get passed the error of maximal size during import.
I do have emails with embedded pictures in the SQL DB. Is that the problem? If so, if I import a snapshot without attachments, will all these pictures disappear? Does the imported snapshot do a complete overwrite? I guess so.
Thanks for your help.
Nobody replied yet although this is an urgent matter. Thanks for your help.
I don't have a bunch of experience with this, but I remember reading an article about managing large backups. I believe you can get one into the system using their Acumatica ERP Configuration tool. I don't have the exact steps and am unable to find the relevant post, but it went something like this. You have to locate your Acumatica installation folder (Not the site, but of the configuration program). There should be a Database folder with a sub folder of Data. You can find all of the Demo folders here. If you follow their structure and add your Snapshot here, their tool will let you load it into an instance. Then, it should be just like setting up a company using the SalesDemo data.
I don't really have any more that this since I have never personally done this and can't for the life of me find the article. If you do start playing around with this, make sure you do it in a test environment before the real thing.
To answer your other questions, your pictures and attachments will disappear if you import without them. Sadly it's not smart enough to do a merge, so even if you put it on top of the original they will still be gone if you import this way.
You might try a Snapshot without any attachments to (hopefully) get the size under 1GB to confirm that it is indeed a size issue.
I like the idea from @wyatt-erp but it does require access to the server to pull it off. Once you do get server access, restoring from a Database backup might be a better option.