Restore an older dynamics GP 10 backup Database

(0) Share

Report

Posted on by Community Member

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

All responses (2)

Answers (0)

Gabe Kressel 20 on at

Like (0)

Report

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 190 on at

Like (1)

Report

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...