Common tasks related to Environment movement of CRM
Here are Common tasks related to Environment movement of CRM How to change SQL server instance name: Check server instance name select @@servername Drop Old server: sp_dropserver <old_name>; Go Create new server sp_addserver <new_name>, local; Go Restart sql service is advisable SQL server backup and restore 1. Back up the Organization _MSCRM database and the MSCRM_Config database. To do this, follow these steps: a. On the computer that is running SQL Server, click Start , point to All Programs , point to Microsoft SQL Server 2008 r2 , and then click SQL Server Management Studio . b. Expand Databases , right-click the Organization _MSCRM database, point to Tasks , and then click Back Up . c. Under Destination , add the location to save the backup file, and then cli...