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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Restoring same CRM Organization twice to an environment

(0) ShareShare
ReportReport
Posted on by 262

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.

 

I have the same question (0)
  • David Jennaway Profile Picture
    14,065 on at

    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

  • samalex1701 Profile Picture
    262 on at

    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.

  • Suggested answer
    Charles Abi Khirs Profile Picture
    3,569 on at

    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

  • Suggested answer
    WCL Profile Picture
    140 on at

    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

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…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 61

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 52 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans