Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Restore an older dynamics GP 10 backup Database

Posted on by Microsoft Employee

Hi

Coludí your tell me what happend if restore and older Dynamics Gp 10 backup database. I am considerando this beca use I do not have syMenuMstr backup and i have an issue on this table so I  think the only way to solve this is restoring an older backup of dynamics database.

Am I right?

Thanks a lot

*This post is locked for comments

  • Gabe Kressel Profile Picture
    Gabe Kressel 20 on at
    RE: Restore an older dynamics GP 10 backup Database

    I would personally recommend to have a copy of your Dynamics CRM backup in the Skyvia cloud to be able to restore it in case anything happens with the data.  

  • Andrew Hall Profile Picture
    Andrew Hall 190 on at
    RE: Restore an older dynamics GP 10 backup Database

    Hi EIl, The answer is depends , it depends on what modules you are using and whether you have created any new companies or added new users since that last DYNAMICS backup was taken. If your using Analytical accounting for instance that holds a lot of information on the dynamics database. also user master tables etc are on the dynamics database as well as the company master all of which will cause you problems if they have more recent entries than the last backup. not to mention any new modules you may have installed. I would avoid restoring the Dynamics database unless it is a very recent backup.

    If your table does not physically exist , I would force restore your backup of the dynamics database to another database (created specifically for this purpose) , then use SQL to script out the table and its dependencies. then after taking a backup of the current database run the create scripts you have just created to re create the table. I believe the syMenuMstr should re populate on launch.

    But before you do anything TAKE A BACKUP...

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans