Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Dynamics and Company database daily backup to cloud

Posted on by Microsoft Employee

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

  • Kaileybr Profile Picture
    Kaileybr 5 on at
    RE: Dynamics and Company database daily backup to cloud

    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.

  • Marlena A. Stark Profile Picture
    Marlena A. Stark 21 on at
    RE: Dynamics and Company database daily backup to cloud

    I would suggest following our best practices:

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

     

    Marlena Stark 

    www.dexprodynamics.com

  • RE: Dynamics and Company database daily backup to cloud

    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

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Dynamics and Company database daily backup to cloud

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics and Company database daily backup to cloud

    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.

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Dynamics and Company database daily backup to cloud

    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.

  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: Dynamics and Company database daily backup to cloud

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans