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.
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
Concepts
Install Microsoft Dynamics CRM Server 2011 to use a Microsoft SQL Server cluster environment
Configure an organization database for SQL Server 2008 database mirroring