Solved

Moving a CRM 4 DB to a new SQL Server

Posted on 2011-03-22
5
921 Views
Last Modified: 2012-08-13
Hi All,

I have an existing CRM Server which has Server 2003 SP2, SQL 2005 SP4, SSRS, and CRM 4 R14. We have one Organization only, and hence only 2 databases: xyz_MSCRM and MSCRM_CONFIG.


I now want to run this on a virtual machine. So I created a VM with Server 2003 SP2, SQL 2005 SP4, SSRS, and CRM 4 R16 (note a newer rollup). This VM has empty databases called xyz_MSCRM and MSCRM_CONFIG (same names as on physical server).

I tried following the steps on http://support.microsoft.com/kb/952934: I back up my 2 DBs, and put the backups on my VM. However, I am not able to restore my DBs. When I try to restore xyz_MSCRM, I get an error:
 crmdb
The folder ftcat_documentindex_ad40cc6a45c74a... does exist on my original physical server, but the equivalent folder on my new VM has a different alphanumeric string. I tried copying the original folder over to the VM as well, but I get the same error.


I tried doing the MSCRM_CONFIG DB as well, and here I get the error:
 configdb
I am at a loss as to how to proceed. Thanks in advance for the help.
0
Comment
Question by:ragnarok89
  • 3
5 Comments
 
LVL 8

Author Comment

by:ragnarok89
Comment Utility
So... it seems that I have to drop the new/empty DBs on the VM, and THEN restore the production DB backups. This is in progress now.
0
 
LVL 8

Author Comment

by:ragnarok89
Comment Utility
OK, DB's imported, but it still doesn't work. I believe I have to import the organization, however this process stops me cold when I get to the user mapping screen. We have 6 disabled users who no longer are part of our AD domain.  There is no way to ignore these records...
0
 
LVL 15

Accepted Solution

by:
WilyGuy earned 500 total points
Comment Utility
OK so taking a swing at this.

Are you moving CRM or creating a TEST environment?  the important factors are the AD Security Groups and the MSCRM_CONFIG DB.

From the way you started, it appears that you are trying to install a new environment.

Based on what you've said, you already installed CRM, so you probably have new AD Groups.

Normally you only need the xyz_mscrm database when you want to do the import.  it might be easiest for you if you can restore your VM to prior to the CRM install.  Reinstall CRM and call your new org ABC.  At the end of this you will have mscrm_config and abc_mscrm in SQL and your new AD Groups.  then restore xyz_mscrm to SQL (it won't overwrite anything).

then in Deployment Manager you can import the new xyz org.  You should be able to map your users and you can leave the 6 disabled users blank (it may throw an error but you should be able to continue).  I have seen some weirdness to the user mapping as well.  Let me know how you get on with this as the problem you saw initially may have been due to overwriting the mscrm_config.

0
 
LVL 3

Expert Comment

by:John Stevens
Comment Utility
I ran into this as well ( the users that had been removed from the AD) and it wouldn't let me continue untill I had recreated the users in AD ( didn't bother with giving them exchange accounts as they were going to be disabled accounts once the import ran) and placed these AD accounts in an OU called Disabled accounts for CRM once I did that the import went through fine.

0
 
LVL 8

Author Comment

by:ragnarok89
Comment Utility
I finally figured it out.

I had to map each CRM user one by one to their AD account. Obviously, I skipped over the CRM users who are no longer in AD. When I tried to continue, I got a warning dialog as before, but I was able to continue. Since that was the last step, the wizard closed, and I now have a working TEST environment that is an exact duplicate of my production environment.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now