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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Restore Database to lo...
Microsoft Dynamics GP (Archived)

Restore Database to local machine from Live

(0) ShareShare
ReportReport
Posted on by babubaskaran@outloo... 12

I have restored a backup from live server to Local GP install and local SQL server.  The SQL collation is same as live server after restoring the back as a new database in local, ran GP utilities but when I login to GP the new company is not getting listed.  What I am missing.

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Whatever companies that are listed in the DYNAMICS.SY01500 tables are what you will see listed in GP Utilities when you log in as 'sa'. You must restore both the DYNAMICS database and your company databases.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Richard,

    Thanks so I can copy both Dynamics and company from live to local install.  I have created the sample company on local do I have to remove that please confirm.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    To play it safe copy all databases. So I would drop all existing GP databases and then  copy over all production databases.

  • Verified answer
    Tom Cruse Profile Picture
    Tom Cruse 1,477 on at

    To chime off of what Richard said, the company needs to be in SY01500 but if you don't want all companies restored you can run utilities to create a new company, call it the same as the live company being restored and then restore your backup over the newly created company.

    By not restoring Dynamics you'll be missing some key settings that match your live company like security settings but nothing that can't be over come.

    Regards,

    Tom Cruse

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Tom, if I were you, my handle would be 'Maverick'.  I'm sure you've never gotten that before :)

  • Tom Cruse Profile Picture
    Tom Cruse 1,477 on at

    "I feel the need... the need for GP speed"

    Sorry... Couldn't hold back the cheesy spin off to add GP into it the quote.

    Only makes sense :)

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    LOL - good one!

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans