Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Restoring same CRM Organization twice to an environment

Posted on by 256

I'm running into an odd issue with setting up a second organization in our Test environment.  Here's our current layout:

Prod Server

- Organization 1 - DBName - MAIN_MSCRM  //  Org Name - MAIN

Test Server

- Organization 1 - DBName - MAIN_MSCRM // Org Name - MAIN

I need to create a second copy of Prod on the Test server for UAT, so I backed-up Prod, restored to Test with the DB Name UAT_MSCRM, and I started the Org Import process. UAT_MSCRM was the only database that showed up, I named the Org 'UAT', and it ran without issue.  So now I have this on the Test Server:

- Organization 2 - DBName - UAT_MSCRM // Org Name - UAT

But when I browse to the new UAT test organization instead of showing the copy of Prod it's presenting the organization that was already on Test (MAIN Org on Test server).  In checking MSCRM_CONFIG.dbo.Organization I'm finding the new ORG UAT is now there, but it's using DB Name MAIN_MSCRM instead of UAT_MSCRM.  When I setup the Org Import I did select UAT_MSCRM which was the only option available, so can someone give any input on why this is happenign?   This is CRM v8 On Prem.  On the Test server I can browse to both MAIN and UAT organizations and see the same data - updating something in one shows on the other so I know they're the same -- plus we changed the theme in Test so we know it's not Prod -- and the theme is showing up on both Test organizations now.

So what happened ???  Are GUID's getting crossed since on Test both organizations would have been restored from the same original Organization on the Prod server?  Since we depend heavily on the MAIN or in Test for testing our processes I removed the UAT organization from Test, and now the MAIN organization that was there no longer loads.

Thanks for any insight on what happened and how to get the MAIN org on Test back up. I'm about to drop and re-add MAIN to see if that reconnects everything, if not I'll restore the databases from backup.

 

  • Suggested answer
    WCL Profile Picture
    WCL 140 on at
    RE: Restoring same CRM Organization twice to an environment

    Yes it gets screwed up if 2 ORG db's were from the same GUID. Set OptimizeOrgImport DWORD registry entry to 0 under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM .. that automatically gives a new GUID to the db being imported.  Delete or set to 1 once you are done if you want to restore default setting

  • Suggested answer
    Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at
    RE: Restoring same CRM Organization twice to an environment

    Hello,

    Delete the organisation from the Deployment Manager

    Delete the UAT_MSCRM from the SQL Server

    Restore your backup database with a totally new name and by removing any link to the MAIN_MSCRM (I think the issue is from here where it still pointing to the original database because of the same name on PROD and UAT)

    Import your organisation from the Deployment Manager by pointing to the new DB

  • samalex1701 Profile Picture
    samalex1701 256 on at
    RE: Restoring same CRM Organization twice to an environment

    You're right .. our business name and info is in the org and db names, so I modified them in the example. Forgot to add the _MSCRM to it, those are there.  The odd thing was that restoring an organization to the TEST server a second time seemed to tie it to the first Org even though the DB Name and Org Name I was using were different.

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: Restoring same CRM Organization twice to an environment

    That does sound odd. One thing to consider is that CRM did have an expectation that organization databases had database names ending _MSCRM. I thought that requirement had gone away, but I'd suggest using database names in that format - e.g. MAIN_MSCRM and UAT_MSCRM

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans