Configure an organization database for SQL Server 2008 database mirroring

  • Article

 

Applies To: 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.

Note

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

Install Microsoft Dynamics CRM Server 2013
Install Microsoft Dynamics CRM Server 2013 to use a Microsoft SQL Server 2008 cluster environment
Configure a Microsoft Dynamics CRM organization for database mirroring
Monitor and test for failover
Install Microsoft Dynamics CRM Server 2013 on multiple computers
Set configuration and organization databases for SQL Server 2012 AlwaysOn failover