Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Configure an organization database for SQL Server 2008 database mirroring

Microsoft Dynamics CRM uses two databases, configuration and organization. The configuration database contains configuration information that is specific to the Microsoft Dynamics CRM system. The organization database is used to store all the organization-specific data and the customer relationship data for the organization. Some versions of Microsoft Dynamics CRM let you create and use multiple organizations. Therefore, some deployments may have multiple organization databases in the Microsoft Dynamics CRM system.

To mirror a Microsoft Dynamics CRM organization database that can automatically fail over to another computer that is running Microsoft SQL Server, you configure the following three computers to establish the SQL Server database mirroring session:

  • Primary database computer. This computer runs SQL Server where the Microsoft Dynamics CRM organization database is located. In this example, Microsoft Dynamics CRM is installed and running on the default instance of SQL Server. The computer name is MSCRM_Primary.

  • Mirrored database computer. This computer, with a connection to MSCRM_Primary, is running SQL Server and it uses a different default instance. This computer must have a network connection to MSCRM_Primary. The computer name is MSCRM_Mirror.

  • Witness computer. This computer runs SQL Server, or it can be a desktop system that is running SQL Server 2005 Express Edition. This computer must have a network connection to MSCRM_Primary and MSCRM_Mirror. The computer name is MSCRM_Witness.

noteNote
A computer that is running Microsoft SQL Server 2008 Workgroup edition can be a Witness. However, it cannot be a Primary or Mirror computer in a database-mirroring session.

See Also

Send comments about this article to Microsoft.

© 2013 Microsoft Corporation. All rights reserved.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.