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,
- Select Device.
- Click on … (Browse) button.
- Click on Add.
- Browse bak file that you would like to create Org in MSCRM.
- 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.
Discover more from Arun Potti's Power Platform blog
Subscribe to get the latest posts to your email.
Reblogged this on SharePoint & CRM and commented:
Very useful step-by-step guide for those making the move to CRM 2016
[…] https://arunpotti.wordpress.com/2015/04/29/how-to-import-crm-orgnization-using-crm-sql-server-backup… […]
oh man…..you are too good
even after paying 25000 for MS CRM training they will not explain 50% in the way u projected here…
Thank You
Thank you very much for such wonderful document.