Export (0) Print
Expand All

Configure an organization database for SQL Server 2008 database mirroring

Applies To: Microsoft Dynamics CRM 2013

Microsoft SQL Server 2008 high-availability solutions improve the availability of servers running SQL Server and databases that contain Microsoft Dynamics CRM data. However, for greater flexibility and operability, consider using Microsoft SQL Server 2012 AlwaysOn failover clusters. More information: Set configuration and organization databases for SQL Server 2012 AlwaysOn failover

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 2008 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 2008 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 2008, or it can be a desktop system that is running Microsoft 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.

© 2014 Microsoft Corporation. All rights reserved.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft