This blog discusses a number of Microsoft technologies, including Microsoft Dynamics CRM, Microsoft Office Project Server, Microsoft SharePoint Server and others.
The previously mentioned computers (MSCRM_Primary, MSCRM_Mirror, and MSCRM_Witness) must all have a network connection and must be running an edition of SQL Server that supports database mirroring.
To mirror the organization database, follow these steps:
To do this, right-click the SQL user name, click Properties, in the User name box, right-click the whole value, and then click Copy. Then, in a text editor such as Notepad, paste the contents. Repeat these steps for each group until you have the contents for all three groups.
Update Organization set ConnectionString = ‘Provider=SQLOLEDB;Data Source=MSCRM_Primary\SQL1;Failover Partner=MSCRM_Mirror\SQL2;Initial Catalog=Organization_MSCRM;Integrated Security=SSPI’ where DatabaseName = ‘Organization_MSCRM’
Update Organization set MirroredSQLServerName = ‘MSCRM_Mirror\SQL2′ where DatabaseName = ‘Organization_MSCRM’
Source: Microsoft Corporation
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics