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 :
Finance | Project Operations, Human Resources, ...
Answered

How to restore company database in GP?

(0) ShareShare
ReportReport
Posted on by 50

Hello Team,

I have installed dynamic GP Application on my system with sample company database. How should point GP to existing company database.?

I have tried restore option from local storage which was under tools, it say that database name not match?

Any suggestion, Please help me out.

Thanks and regards,

Satyajit Bhapkar.

I have the same question (0)
  • Verified answer
    Derek Albaugh Profile Picture
    on at
    RE: How to restore company database in GP?

    Restoring a Dynamics GP database isn't any different from any other database when restoring in SQL.

    This document has the step by steps if you need:

    docs.microsoft.com/.../transfer-gp-installation-new-server

    If you need to match the Dynamics GP code to the GP system database you have, you need to go into the Dex.ini file for Dynamics GP, which is usually in the C:\Program Files (x86)\Microsoft Dynamics\GP\Data\ directory and find the line:

    Pathname=DYNAMICS/dbo/

    This should be the name of your system database for Dynamics GP.

    This is how GP knows what system database to look for in SQL, then it uses the SY01500 and other tables to find out what company databases it has under that system database.

    Thanks

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans