Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Server Move and Upgrad...
Microsoft Dynamics GP (Archived)

Server Move and Upgrade - Best Practice?

(0) ShareShare
ReportReport
Posted on by Bron 2

My client is currently running GPV10 on SQL2000. Their current SQL server is also the domain controller on their netowrk.

They have purchased a brand new SQL server. It has Server2008 for an operating system already installed. SQL is not yet installed.

How should they proceed?

1. Load SQL2008 onto new server

2. Move GP data over to new server (do they also bring over the tempdb, master, model and msdb databases?)

3. Change compatibility level of the GP databases

4. Test - Test - Test........

 What am I missing?

 Thank you in advance.......

*This post is locked for comments

  • Bron Profile Picture
    Bron 2 on at
    Re: Re: Re: Server Move and Upgrade - Best Practice?

    Thanks to both Charles and Ron for their advice.

     I think I have what I need.

     Regards,

    Bron

  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at
    Re: Re: Server Move and Upgrade - Best Practice?

     I would have to say the VERY FIRST THING TO DO is get a reliable BACKUP!!!!  I cannot stress this enough.  I had an upgrade and server move go bad on me a few years back and had I not had a backup EVERYTHING would have been lost.  I would make 2 backups and put them in 2 different places!!!

  • callen Profile Picture
    callen 4,595 on at
    Re: Server Move and Upgrade - Best Practice?

    There is a knowledgebase article KB878449 on this very subject.

    If you want to capture the users, there is a script for capturing them and restoring them on the new server.

    You would not bring over the system databases you mentioned.

    You will want to script any jobs that are running on the existing server.

     

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans