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) / 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

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

    See if this article will be of assistance.

    www.techrepublic.com/.../5025441

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    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

  • pclerie Profile Picture
    pclerie 160 on at

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    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

    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,850 Moderator on at

    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

    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,850 Moderator on at

    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

    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,850 Moderator on at

    Good job! Glad to hear you are back online.

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