Hi all,
I am backing up Dynamics and Company database daily using a external HDD and it is time consuming.
I am wondering how do you guys do daily backup. Should I use Azure to backup daily? Any cost/time efficient way to do backup?
I tried blob storage from Azure, but it requires to login GP and backup each database manually.
*This post is locked for comments
I had the same problem. I had big problems with the backup setup. Since I work as a videographer, I constantly run out of memory on my computer. And I had to manually upload all the files to the cloud storage every evening. I was very tired of this and decided to find something else. It's good that my friend advised me on cloud storage Specialists in delivering scalable technology. The coolest thing is that you can set up automatic backups in this cloud storage, which is very convenient.
I would suggest following our best practices:
Best practice for SQL maintenance and backups for GP clients - Dexpro Dynamics
Marlena Stark
I work for WebMD. We are looking to put together a DR plan. Would you have any documents regarding that? Does Microsoft publish anything that recommends best practices when it comes to putting together a DR plan?
Thanks
Hi Eric,
Indeed, this was introduced back in version 2012.. but there are some caveats to keep in mind. Read further : www.mssqltips.com/.../sql-server-managed-backups-to-azure
Thank you Praveen and Beat for those useful info.
I just found out Microsoft Azure Backup Server should be the way to go.
It can backup and recover SQL database from Azure cloud storage.
Hi,
Praveen provided you with a link that goes over all the best practices for local backups on your Dynamics GP environment.. which is a good starting point. Backing up your daily SQL backups to an external HDD may show that your company doesn't have an extended DR (Disaster Recovery) plan, which is somethign I'd be concerned by.
There is currently no documentation I'm aware of from Microsoft regarding cloud-backup for Dynamics GP.. but there are a few things to consider in the larger sense of a DR scenario:
You could find a hosting partner to run your GP databases.. You'll keep running the full GP client (aka fat client), but your users would remote access into the ISV/Hosting provider.. The provider will be responsible for all the backups in the cloud.
There are a few well-known Backup solution providers (just google it) that will offer you a montly plan to include the upload of your server backups to the cloud.. which in my opinion is already better than an external HDD (unless you have a very poor internet connexion, but then we're not talking about cloud backup anymore).
A local tape robot is already better than individual HDD's, since you can automate the whole process way better and ship the tapes daily out to a vault (like Iron Mountain can provide as a service for a few dozen $/month).
All in all, it's not only about your ERP backups, but the whole DR strategy that you should look at for your company.
Good luck.
PS: I've been presenting UG sessions at GPUG Summit for 2 years about DR and GP. Let me know if you're interested in the material.
Hi,
Please check below links which might be helpful for your requirement,
www.erpsoftwareblog.com/.../recommendations-for-a-backup-policy-for-microsoft-dynamics-gp
Thanks,
Praveen
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156