Dynamics and Company database daily backup to cloud

(1) Share

Report

Posted on by Community Member

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 have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Praveen Kumar RR 1,552 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
cwolin@webmd.net 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Marlena A. Stark 21 on at

Like (0)

Report

I would suggest following our best practices:

Best practice for SQL maintenance and backups for GP clients - Dexpro Dynamics

Marlena Stark

www.dexprodynamics.com

Was this reply helpful? Yes No
Kaileybr 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No