Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / moving gp 2010 to new ...
Microsoft Dynamics GP (Archived)

moving gp 2010 to new server

(0) ShareShare
ReportReport
Posted on by pclerie 160

Our regular SQL Server 2008 has stopped working because "database 'model' is marked RESTORING and is in a state that does not allow recovery". I've tried several things that did not work and over at Technet, I was encouraged to reinstall. But before I do that I need to move my database to another server.

I've recovered one application. Now I need to recover Dynamics.

First order of business is to recover the SQL logins as outlined in the Howto at support.microsoft.com/.../878449. However since the server won't start I don't have access and I cannot run the supplied script.

I thought I would rename the files, attach them to a new server and run the script there. But, it looks like even the new server continues to see those files as database "master". So I did not go through with the attach.

Is there another way I can attach the old master db to a new server under another name?

Or is there a way on Dynamics to recreate the SQL logins?

Hoping there's an answer!

Thanks in advance.

Philippe

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: moving gp 2010 to new server

    User Security setup failed  Error Message said--> This user ID is being edited by another user.

    please help me. i had move to new server, every going well accept this one. please

    T_T

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: moving gp 2010 to new server

    Good job! Glad to hear you are back online.

  • pclerie Profile Picture
    pclerie 160 on at
    RE: moving gp 2010 to new server

    Thanks for all the help! I thought I'd let you know that I recovered the old server. The short story is that I restored all the system database from just prior to the last know reboot. That was a week before the crash. Now we're back online.

    Backups are good!

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: moving gp 2010 to new server

    Make sure you remove them from each database plus from SQL. When you pull one up and click Save you should get a prompt about corresponding information is  missing do you want to continue. Just click Yes and it should fix them in SQL. Then you can assign user access.

    You will see them under security for each database plus you will see them under security in SQL. They must be removed in both places.

  • pclerie Profile Picture
    pclerie 160 on at
    RE: moving gp 2010 to new server

    any idea why some user ids are more sticky than others? I have deleted most stale ids; also some active ids that we were able to recreate; the rest, we can't change the passwords, we can't delete, and they can't be used.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: moving gp 2010 to new server

    You need someone familiar with SQL to remove the users from the databases in SQL. I do this type of stuff all the time. It would be hard to describe in this little box what needs to be done. Sounds like you have the right people working on this. Let me know if any help is needed down the road.

    The login script in TK 878449 couild be modifed to use the DYNAMICS..SY01400 table. This would at least give you the GP users.

  • pclerie Profile Picture
    pclerie 160 on at
    RE: moving gp 2010 to new server

    We're only talking about a dozen users, so it would not be the end of the world to re-enter them manually. But there were errors when attempting to delete existing users to recreate the logins.

    Can't use TK878489 because I can't start the old server to run the script against master and I can't user master on a fresh server so I can run the script.

    We called in outside support and the guy is recreating the entire thing from scratch as we speak.

    When all else fails, reinstall. The Windows way! :-(

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: moving gp 2010 to new server

    How many users are we talking about here? Do you have backups of the DYNAMICS and company databases? To my knowlege, you cannot just copy the system databases from one server to another. If you can do a server move as in TK 878449 you could actually build the login script using the user list in the DYNAMICS database(SY01400) that will exist on the new server. This will at least cover the GP users.

  • pclerie Profile Picture
    pclerie 160 on at
    RE: moving gp 2010 to new server

    Hi,

    Thanks for you help. But I'm a bit confused. Let's call the old server O and the new one N. What I think you're saying is that I should move O.master to the new server along with the databases that were on O. That would overwrite N.master which is probably a no-no while the server is running.

    So I stopped the server first and overwrote O.master with N.master. Now the server does not start. I get error 1814: Cannot create tempdb.... I guess it's unable to read the new master database.

    I made a new installation of SQL Server Express on a VM, using the default instance. The problem server also uses a default instance.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: moving gp 2010 to new server

    Name the new server the same as the old server exactly.  Then move the Master files/db to the new server along with the Dynamics DB and your company dbs and log files.  Attach them to the new server.  For the master, take the server down, move the old master db and log files somewhere else and put the old master tables where the new ones were.  Then restart the server and attach the Dynamics and company dbs and logs

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans