locked
Multiple Server RRS feed

  • Question

  • Does MS  CRM support installing the system in multiple instances for DR and how?
    hussain
    Monday, May 4, 2009 8:45 AM

Answers

  • Hi Hussain,

    there is no special support for CRM-replication by Dynamics CRM itself.

    If you create such Replication you have to know how your Replication is created an which scenarios are supported.

    Best regards,
    Jürgen


    Jürgen Beck

    Dipl. Kfm./Wirtschaftsinformatik
    MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
    Microsoft Certified Business Management Solutions Professional
    Microsoft Certified CRM Developer
    Microsoft Certified Trainer

    ComBeck IT Services & Business Solutions
    Microsoft Gold Certified Partner
    Microsoft Small Business Specialist

    Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors

    http://www.combeck.de
    Monday, May 4, 2009 12:15 PM
    Moderator

All replies

  • Hi Hussain,

    what di you mean with "DR"?

    You can install CRM 4.0 Server one time per Windows System. But you can add multiple instances per setup to have separated databases. You can do this with Deployment Manager and Enterprise Edition.

    Best regards,
    Jürgen
    Jürgen Beck

    Dipl. Kfm./Wirtschaftsinformatik
    MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
    Microsoft Certified Business Management Solutions Professional
    Microsoft Certified CRM Developer
    Microsoft Certified Trainer

    ComBeck IT Services & Business Solutions
    Microsoft Gold Certified Partner
    Microsoft Small Business Specialist

    Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors

    http://www.combeck.de
    Monday, May 4, 2009 9:00 AM
    Moderator
  • Does this mean that i have to end up with ONE SQL server??
    hussain
    Monday, May 4, 2009 9:09 AM
  • Hi Hussain,

    One SQL Server instance is necessary for one CRM Server instance. Multiple CRM-Organizations can be installed on one SQL Server because they are different in their names, but it is not necessary. If you want you can also save your Organization databases on different SQL Server but this is not necessary.

    Best regards,
    Jürgen


    Jürgen Beck

    Dipl. Kfm./Wirtschaftsinformatik
    MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
    Microsoft Certified Business Management Solutions Professional
    Microsoft Certified CRM Developer
    Microsoft Certified Trainer

    ComBeck IT Services & Business Solutions
    Microsoft Gold Certified Partner
    Microsoft Small Business Specialist

    Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors

    http://www.combeck.de
    Monday, May 4, 2009 9:48 AM
    Moderator
  • I want o make sure in case of a disaster that i can run the system from another location.

    so Can u build the replica of the existing system somehere else?? this is my question

    Which is application and database
    hussain
    Monday, May 4, 2009 10:01 AM
  • Hi Hussain,

    you just have to store the configuration-database MSCRM_COONFIG and the organization databases XXX_MSCRM.

    There is additional information in the CRM 4.0 Implementation Guide (Microsoft_Dynamics_CRM_IG_Operating.doc, Chapter 4)

    Best regards,
    Jürgen



    Scenario A: SQL Server Failure

    If the computer that is running Microsoft® SQL Server® fails, you must restore the databases from backup, and then reassociate them with the Microsoft Dynamics® CRM deployment. The following steps are required to return Microsoft Dynamics CRM to full functionality:

    Scenario-A Recovery

    1.   Install Microsoft Windows® Server 2003 or Windows Server 2008, making sure that the computer is in the same domain as the Microsoft Dynamics CRM server. In addition, you should use the same database name and disk structure. If you change either of these, you must take additional steps to correctly restore the SQL Server databases.

    2.   Install SQL Server.

    3.   If you have a valid backup of the master database, restore that backup. (For more information, see "Restoring the master Database" in SQL Server Books Online (http://go.microsoft.com/fwlink/?LinkID=100240).

    4.   Restore the msdb database. (For more information, see “Restoring the model and msdb Databases” in SQL Server Books Online (http://go.microsoft.com/fwlink/?LinkID=100244).

    5.   Restore the MSCRM_CONFIG and Organization_name_MSCRM databases. (For more information about how to restore databases, see “Backing Up and Restoring Databases” (http://go.microsoft.com/fwlink/?LinkID=100249).

    6.   If Microsoft SQL Server Reporting Services and the Microsoft Dynamics CRM SRS Data Connector are also installed on the instance of SQL Server, restore the ReportServer, and ReportServertempDB databases. (For more information about how to restore databases, see “Backing Up and Restoring Databases”  (http://go.microsoft.com/fwlink/?LinkID=100249).

    7.   If you restored the MSCRM_CONFIG database, you must run Microsoft Dynamics CRM Server Setup and use the “Connect to existing databases” option on the Specify Deployment Options page. If you did not restore the MSCRM_CONFIG database and the database is functioning correctly, you use the Import Organization feature in Microsoft Dynamics CRM Deployment Manager to re-associate the organization database with the Microsoft Dynamics CRM system. For more information about how to import an organization, see the Deployment Manager Help.

     

    This scenario is a worst-case situation, that is, total failure of the computer that is running SQL Server. In other circumstances, such as the failure of a disk, you may only have to restore a single database to recover the environment.

    For more information about failure recovery for SQL Server, see "Disaster Recovery" (http://go.microsoft.com/fwlink/?LinkID=100252).


    Jürgen Beck

    Dipl. Kfm./Wirtschaftsinformatik
    MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
    Microsoft Certified Business Management Solutions Professional
    Microsoft Certified CRM Developer
    Microsoft Certified Trainer

    ComBeck IT Services & Business Solutions
    Microsoft Gold Certified Partner
    Microsoft Small Business Specialist

    Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors

    http://www.combeck.de
    Monday, May 4, 2009 10:06 AM
    Moderator
  • Jürgen,

    Thank you for the quick response.

    But is there any scenaro by hacing two active Application with two active database?

    for Example Location A has (1 appliction server and 1 database server)  then Location B has the same (1 appliction server and 1 database server)
    by this scenario replication will be on both side from A to B and B to A.

    ??
    hussain
    Monday, May 4, 2009 12:12 PM
  • Hi Hussain,

    there is no special support for CRM-replication by Dynamics CRM itself.

    If you create such Replication you have to know how your Replication is created an which scenarios are supported.

    Best regards,
    Jürgen


    Jürgen Beck

    Dipl. Kfm./Wirtschaftsinformatik
    MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
    Microsoft Certified Business Management Solutions Professional
    Microsoft Certified CRM Developer
    Microsoft Certified Trainer

    ComBeck IT Services & Business Solutions
    Microsoft Gold Certified Partner
    Microsoft Small Business Specialist

    Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors

    http://www.combeck.de
    Monday, May 4, 2009 12:15 PM
    Moderator
  • Thank you so much
    hussain
    Monday, May 4, 2009 3:19 PM