I’m looking for a best practice concerning SQL backup. Is there a Acumatica-specific recommended recovery model (simple vs full) or is it based on standard recovery considerations?
SQL best practices
Hello jyounker18,
Based on your question, I assume you have Acumatica ERP installed on premise. This means that you have several options on how to configure a backup/restore procedure.
There is so much to say about SQL Server recovery configuration (I assume you will be using SQL Server database management system). If you have to get a detailed description of the choices please search on the internet on the subject. There are hundreds of good articles and it is worthy spending some time to learn and understand backup/restore as this is a mission critical procedure for your production environment.
So I am going to write down few lines on this subject so you will know where to start your readings:
If using simple recovery model , the recovery will depend solely on the full database backup files. This means , if you run a full backup every night and your database crashes after that, you will recover your database to the data in the backup file of the night before which means that you loose all the transactions done from the time of the last backup up to the time of the crash.
Therefore, it is highly recommended to use Full recovery model on Production environments. But this also requires running transaction log backups which will allow you to recover your database to a point close to the time of the crash, depending on the frequency of the transaction log backups.
Depending on the resources available (disks , servers, etc.) , you may be able to decrease the down time during a disaster recovery by using Log Shipping or Mirroring.
As you can imagine now , it is not a simple subject an you may want to start your readings here:
But if you need to setup and start your Acumatica production environment soon, it will be wise to contract the services of an experienced database administrator to help you kicking off and ensuring you have a secure and bullet proof recovery procedure.
i hope this helps.
I want to add that mirroring is a great option to have as backup and best practices as suggested on this post, BUT!!! Anyone out there that has this feature ON and is upgrading from any Acumatica version equal o less than 2023R1.xxx to 2023R2.xxx or need to pass by this version 2023R2.xxx to climb the upgrade ladder- TURN IT OFF!! or you will encounter this error messages:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1a64326d-19c3-4499-9fa3-d826c999a22b.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/7d3049fd-073f-4384-b3e1-0968c564ed79.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c5487225-141d-4cdf-9ae3-94464651e33a.png)
My ISV and I spent a great amount of valuable time until this issue was figured out. Hope this helps.
Especial thanks to @Heuristyc ISV team- Gabriel, Alejandro, Diego y Cesar.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.