MSCRM Migrating a database server

Move the Microsoft Dynamics CRM databases to another SQL Server and SQL Server Reporting Services Server in the same domai N, and leave the Microsoft Dynamics CRM server on the existing Server

1. Back up the ORGANIZATIONNAME_MSCRM database and the MSCRM_Config database. To does this, follow these steps:
   
   
   1. on the computer that's running Microsoft SQL Server, click  Start , point t o  All Programs , point to , Microsoft SQL Server $ , and then click < Strong>sql Server Management Studio .
      
      
   2. in the  Connect to Server  window, type the name of the server it is running Microsoft SQL Server the  Server  name box and then click  Connect .
      
      
   3. expand  Databases , right-click the OrganizationName_MSCRM database, point to& nbsp Tasks , and then click  back up .
      
      
   4. under  Destination , add the location to save the backup file, and then click  OK .
      
      
   5. Repeat Steps 1b and 1c for the MSCRM_CONFIG database.
      
      

   Note
   If You must move more than one organization, repeat steps 1a-1d for each organization database.

2. Restore the ORGANIZATIONNAME_MSCRM database and the MSCRM_Config database on the new computer, which is running SQL Server. To does this, follow these steps:
   
   
   2. On the new computer, click- Start, point-to-all- Programs , point-to- Microsoft SQL Server, a nd then click SQL Server Management Studio.
      
      
   4. In the Connect to Server window, type the name of the server so is running Microsoft SQL server server Name box and then click Connect.
      
      
   6. Right-click Databases, and then click Restore Database.
      
      
   8. Under Destination to restore, type the name of the ORGANIZATIONNAME_MSCRM database in the to database bo X.
      
      
   10. Under Source for restore, click From device, click the ellipsis button (...), add the OrganizationName _MSCRM database, and then click OK.
       
       
   12. Click to select the Restore check box, and then click OK.
       
       
   14. Repeat steps 2b-2e for the MSCRM_Config database.
       
       

   Note
   If You must move more than one organization, repeat steps 2a-2f for each organization database.

3. Update the ConfigDB registry subkey on the computer which is running Microsoft Dynamics CRM Server 2011. To does this, follow these steps:
   
   
   1. on the computer this is running Microsoft Dynamics CRM Server, click  start, click  Run , type regedit in the  Open  box, and then click OK .
      
      
   2. Locate registry Subkey:hkey_local_machine\software\microsoft\mscrm.
      
      
   3. right-click  configdb , and then click  Modify .
      
      
   4. in the  Value data  box, which is the data source to the name of the new SQL Server, and then click  OK . For example, the string value in the Value data box should resemble the following:
      
      Data source= <newsqlservename >r; Initial catalog=mscrm_config;integrated security=sspi
      
      

   Note
   If multiple Microsoft Dynamics CRM roles is in your deployment, you must update the configdb registry key for Al L The server roles. If you use the Microsoft Dynamics CRM Reporting Extensions and if your is not moving the Microsoft SQL Server Reporting Se Rvices server, must update the CONFIGDB subkey on the computer on which the Microsoft Dynamics CRM Reporting Extensions is installed.

4. Configure the Microsoft Dynamics CRM application to the new SQL Server and Microsoft SQL Server Reporting Service S. To does this, follow these steps:
   
   
   2. On the computer, which is running Microsoft Dynamics CRM Server, click Start, point to all Programs, Point to Microsoft Dynamics CRM , and then click Deployment Manager.
      
      
   4. Click organizations.
      
      
   6. Right-click the organization that's moved to the new computer that's running SQL Server, and then click disable.
      
      
   8. Right-click the organization so you disabled, and then click Edit organization.
      
      
   10. Type the new name of the SQL Server and the new URL for the Microsoft SQL Server Reporting Services server.
       
       
   12. Click Next , and then click Apply.
       
       
   14. Right-click the organization that's disabled in step 4c, click Enable, and then click Yes.
       
       
6. If you is using the Microsoft Dynamics CRM Reporting Extensions and if you is moving to a new Microsoft SQL Server Repor Ting Services Server, must install the Microsoft Dynamics CRM Reporting Extensions on the new server so is running M Icrosoft SQL Server Reporting Services.

MSCRM Migrating a database server