I do not have access to the Acumatica DB on SQL using SSIS. Is there a way to backup the entire Acumatica DB and then restore it to a test system from inside of Acumatica?
I am thinking there is not. But I want to be sure.
Thank you,
Answer
Is there a way to copy the entire SQL DB from inside Acumatica?
Best answer by jeffgrammer69
Depending on the db size as in if it is under 2Gb you could take a snapshot and export it in Acumatica. Then run up a test system on the Same version of Acumatica and the in that test system use the import and restore snapshot.
Let me try that and see. I do not think this DB is larger than that. If this works will respond back here.
+17HI
With being SSIS the only thing you are able to do is take a snapshot. Whoever holds your instance on their db would need to get you the back up.
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
+15Depending on the db size as in if it is under 2Gb you could take a snapshot and export it in Acumatica. Then run up a test system on the Same version of Acumatica and the in that test system use the import and restore snapshot.
Dermot Comerford
Depending on the db size as in if it is under 2Gb you could take a snapshot and export it in Acumatica. Then run up a test system on the Same version of Acumatica and the in that test system use the import and restore snapshot.
Let me try that and see. I do not think this DB is larger than that. If this works will respond back here.
Depending on the db size as in if it is under 2Gb you could take a snapshot and export it in Acumatica. Then run up a test system on the Same version of Acumatica and the in that test system use the import and restore snapshot.
Let me try that and see. I do not think this DB is larger than that. If this works will respond back here.
Argh. After an hour to create the Snapshot, which did complete, when I try to “Prepare for Export” I receive an error message regarding not able to insert into CRCase. This is likely due to the customization that was published for the Cases module. Will have to try later tonight when I can try to unpublish all of the customizations and then try to put the system into Maintenance Mode and then try to Prepare.
I am going to “assume”, (and that always puts me in trouble), that if the Snapshot completed, that the DB size is NOT greater than 2GB’s.
+17Hi
Is the snapshot marked as safe? What is the Size on Disk?
Regardless, I would pull the snapshot without the customization.
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
+15Dermot Comerford
Hi
Is the snapshot marked as safe? What is the Size on Disk?
Regardless, I would pull the snapshot without the customization.
Yeah, I will have to wait until this evening to try without customizations. And you are correct, it is NOT marked as “safe”.
I do not know the size on disk, as I suppose my access does not let me see that. At least it is not listed on the snapshot screen
Well, while the snapshot *would* have worked. Apparently, the database continues to error out during the “Create Snapshot” phase even with no customizations published. So, I am a bit out of options. Thank you for all of your suggestions.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.