Will import CRM Organization using Existing SQL Server CRM Database backup file. Follow the below steps,

Step 1: Open SQL Server Management Studio. I am using SQL Server 2012 Enterprise Edition.

Step 2: Provide Server name, Authentication, User name and Password. Click on Connect.

Step 3: Take Backup of the Required Organization before do this Operation. Click here to know how to take backup of MSCRM Organization database backup.

Step 4: Right Click on Databases and click on Restore Database.

Step 5: Follow the below points,

1. Select Device.
2. Click on … (Browse) button.
3. Click on Add.
4. Browse bak file that you would like to create Org in MSCRM.
5. Click OK and Ok.

Step 6: Provide Destination Database Name that you would like to give for New CRM Organization and click ok.

Step 7: Once the database is restored, you can see the below Message and Click on OK.

Step 8: Open CRM Deployment Manager and Click on Import Organization….

Step 9: You can see the below SQL Server and Organization database name automatically. Click Next.

Step 10: Provide Display Name for the New CRM Organization. Automatically Unique Database Name will populate and Click on Next.

Step 11: Report Server URL will auto populate or Provide required URL. Click on Next.

Step 12: Select Automatically Map Users, and click on Next.

Step 13: You will see the list of Active Directory Users. Click on Next.

Step 14: Click on Next.

Step 15: Click on Import.

Step 16: Update Organization is in Progress.

Step 17: Organization imported Succesfully. Click on Finish.

Step 18: Goto CRM Deployment Manager and browse for the Organization that you created.

Please provide your valuable comments on this article.