web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

backup and restore

(0) ShareShare
ReportReport
Posted on by

I have backups from version 1438 and I have created a test company with hotfix 1745 how do I restore from backup 1438?  I keep getting table not matching errors and security errors

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Redbeard Profile Picture
    12,931 on at
    RE: backup and restore

    Larry,

    This one is going to be a bear to troubleshoot with out specific information on the errors you're receiving.  I would imagine the likely cause is you don't have the same products installed on Version 1745 you do on 1438.  Dynamics GP requires additional installation steps for features like Analytical Accounting and Fixed Assets, and if you're missing this application when you're restoring a backup from a previous version, you're doing what we used to call a forced upgrade, and GP is likely seeing tables it doesn't have the application utilities it needs to perform the upgrade.

  • Community Member Profile Picture
    on at
    RE: backup and restore

    The strange part is if I restore back to 1438 and restore the backup I need then apply the hotfix it works perfect.  The problem i'm having is i'm testing purchasing batches so when there all posted I have nothing else to post so I need to do the restore again and it from the 1438.

  • Verified answer
    Redbeard Profile Picture
    12,931 on at
    RE: backup and restore

    Larry,

    Maybe I am not understanding you right, but it sounded like if you apply the 1745 hotfix to the 1438 environment it works fine, but then you don't have the data you want to test on.  Is it possible for you to run the 1745 hotfix against 1438, back up the newly created 1745 database, and restore it into your Test environment?

  • Community Member Profile Picture
    on at
    RE: backup and restore

    That is what I will do.

  • Verified answer
    Redbeard Profile Picture
    12,931 on at
    RE: backup and restore

    Excellent - glad I could help.  There should be a "Did this answer help?" question to the right of any answer I suggested.  If you could click yes on this, it will close out the issue.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans