How to Take Backup MS CRM Organization DataBase

Steps to Take Backup MS CRM Organization DataBase

  1. Back up the OrganizationName_MSCRM databases. To do this, follow these steps:
    1. On the computer that is running SQL Server, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
    2. Expand Databases, right-click the OrganizationName_MSCRM database, point to Tasks, and then click Back Up.
    3. Under Destination, add the location to save the backup file, and then click OK.
    4. Repeat steps 1b and 1c for any other OrganizationName_MSCRM database that must be moved.
  2. Install Microsoft Dynamics CRM 2011 on the new computer that will run Microsoft Dynamics CRM Server 2011.
  3. Install the Microsoft Dynamics CRM Reporting Extensions for SQL ServerReporting Services.Important

    You will not be able to import an organization until the Microsoft Dynamics CRM Reporting Extensions for SQL ServerReporting Services are installed.

  4. Restore the OrganizationName_MSCRM databases on the new computer that is running SQL Server. To do this, follow these steps:
    1. On the new computer that is running SQL Server, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
    2. Right-click Databases, and then click Restore Database.
    3. Under Destination to restore, type the name of the OrganizationName_MSCRM database in the To database box.
    4. Under Source for restore, click From device, click the ellipsis button ( … ), add theOrganizationName_MSCRM database, and then click OK.
    5. Click to select the Restore check box, and then click OK.
    6. Repeat steps 3b-3e for any additional OrganizationName_MSCRM databases.
  5. Import the organization into the new deployment of Microsoft Dynamics CRM 2011. To do this, follow these steps:
    1. On the new computer that is running Microsoft Dynamics CRM Server 2011, click Start, point to All Programs, point to Microsoft Dynamics CRM 2011, and then click Deployment Manager.
    2. Right-click Organizations, and then click Import Organization.
    3. If you are using the Workgroup edition of Microsoft Dynamics CRM, you are prompted to delete the existing organization. Click OK to delete the organization that was created during the installation.

    Note

    This action does not delete the actual OrganizationName_MSCRM database from the server that is running SQL Server.

    1. In the SQL Server box, click the computer to which you restored the OrganizationName_MSCRM database, click the organization database in the Organizationdatabase box, and then click Next.
    2. Type the display name and the name for the organization, and then click Next.
    3. Type the URL in the SQL Server Reporting Services URL box, and then click Next.
    4. Select the method in the Method for the Mapping of the Users list, and then click Next.
    5. Map the users, and then click Next.
    6. In the System Requirements dialog box, click Next, and then click Import.

    Note

    If you plan to use the same Microsoft Dynamics CRM E-mail Router, you must run the Configuration Wizard to configure the router for the new environment.

    You must run the Configuration Wizard for the Microsoft Dynamics CRM for Outlook to connect to the new Microsoft Dynamics CRM Server 2011.

Redeploy the Microsoft Dynamics CRM deployment that includes the Microsoft Dynamics CRM Server within the same domain or to another domain

  1. Back up the OrganizationName_MSCRM databases. To do this, follow these steps:
    1. On the computer that is running SQL Server, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
    2. Expand Databases, right-click the OrganizationName_MSCRM database, point to Tasks, and then click Back Up.
    3. Under Destination, add the location to save the backup file, and then click OK.
    4. Repeat steps 1b and 1c for any other OrganizationName_MSCRM database that must be moved.
  2. Install Microsoft Dynamics CRM 2011 on the new computer that will run Microsoft Dynamics CRM Server 2011.
  3. Install the Microsoft Dynamics CRM Reporting Extensions for SQL ServerReporting Services.Note

    You will be unable to import an organization until the Microsoft Dynamics CRM Reporting Extensions for SQL ServerReporting Services are installed.

Cheers,

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s