Does anyone know how to back up database? I want to start backing up our data periodically and couldn’t find the how-to anywhere. I am using Canadian Localization 25R1.
Thank you in advance.
Solved
Database Back up?
Best answer by Laura03
Hello, below are the steps I follow when making a Snapshot backup.
- Coordinate with users to select a time when everyone can be out of the system for a few minutes.
- In Apply Updates screen, Click Schedule Lockout. Enter the agreed-upon date and time. Click OK.
- At the agreed-upon time, use Active Users tab of System Monitor screen to verify you are the only active User.
- Use Tenants screen to Create Snapshot (button at top). Make a full backup.
- Last, End the Scheduled Lockout in Apply Updates screen.
+20Hello, below are the steps I follow when making a Snapshot backup.
- Coordinate with users to select a time when everyone can be out of the system for a few minutes.
- In Apply Updates screen, Click Schedule Lockout. Enter the agreed-upon date and time. Click OK.
- At the agreed-upon time, use Active Users tab of System Monitor screen to verify you are the only active User.
- Use Tenants screen to Create Snapshot (button at top). Make a full backup.
- Last, End the Scheduled Lockout in Apply Updates screen.
+17What hosting model are you using? If you’re SaaS, this would be handled by Acumatica. If you're on-prem or private cloud, you can create a SQL job to do this on a schedule.
Hello, below are the steps I follow when making a Snapshot backup.
- Coordinate with users to select a time when everyone can be out of the system for a few minutes.
- In Apply Updates screen, Click Schedule Lockout. Enter the agreed-upon date and time. Click OK.
- At the agreed-upon time, use Active Users tab of System Monitor screen to verify you are the only active User.
- Use Tenants screen to Create Snapshot (button at top). Make a full backup.
- Last, End the Scheduled Lockout in Apply Updates screen.
Thank you Laura! I used this procedure when I copied the production tenant to a test tenant last year. I thought there might be another way to back up & create copy of cloud data to a local drive. This would be sort of “a second location” of the cloud back up. Similar to daily server back up if that make sense.
What hosting model are you using? If you’re SaaS, this would be handled by Acumatica. If you're on-prem or private cloud, you can create a SQL job to do this on a schedule.
Thank you Daryl. We are on SaaS.
Hi
As your instance is hosted on Acumatica SaaS, database backups are managed by Acumatica.
you can raise a Support Ticket to request a database backup or instance snapshot. Taking periodic snapshots of your Acumatica instance is recommended.
Hope above helps!!
+20Thank you Laura! I used this procedure when I copied the production tenant to a test tenant last year. I thought there might be another way to back up & create copy of cloud data to a local drive. This would be sort of “a second location” of the cloud back up. Similar to daily server back up if that make sense.
Hello, The Snapshot may be exported and stored locally. As others have mentioned, Acumatica backs up your data regularly. In case of catastrophe, a restore from Acumatica’s latest backup is the obvious solution. Absent a catastrophe, Snapshots are an easy, free way to make intermittent local copies of your tenants.
Laura
Hi
As your instance is hosted on Acumatica SaaS, database backups are managed by Acumatica.
you can raise a Support Ticket to request a database backup or instance snapshot. Taking periodic snapshots of your Acumatica instance is recommended.
Hope above helps!!
Thank you Rakshanda!
Don’t forget that Snapshots are version dependent and can only be restored to the version they were taken from. I believe this is the major version not the patch version.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.