Scenario A: SQL Server failure

  • Article

 

Applies To: Dynamics CRM 2013

If the computer that is running Microsoft SQL Server fails, you must restore the databases from backup, and then reassociate them with the Microsoft Dynamics CRM deployment.

Scenario A recovery

Recover from this failure

  1. Install Windows Server 2012 or Windows Server 2008 and make sure that the computer is in the same domain as the Microsoft Dynamics CRM 2013 server or server roles. In addition, you should use the same database name and disk structure. If you change either of these, you must take additional steps to correctly restore the SQL Server databases.

  2. Install SQL Server. For supported versions, see SQL Server requirements and recommendations for Microsoft Dynamics CRM.

  3. If you have a valid backup of the master database, restore that backup. For more information, see Restoring the master Database in SQL Server Books Online.

  4. Restore the msdb database. For more information, see Restoring the model and msdb Databases in SQL Server Books Online.

  5. Restore the MSCRM_CONFIG and OrganizationName_MSCRM databases. For more information about how to restore SQL Server databases, see Backing Up and Restoring Databases.

  6. If Microsoft SQL Server Reporting Services and the Microsoft Dynamics CRM 2013 Reporting Extensions are also installed on the instance of SQL Server, restore the ReportServer and ReportServertempDB databases. For more information about how to restore databases, see Backing Up and Restoring Databases.

  7. If you restored the MSCRM_CONFIG database, you must run Microsoft Dynamics CRM Server Setup and use the Connect to existing databases option on the Specify Deployment Options page. If you did not restore the MSCRM_CONFIG database and the database is functioning correctly, you can reconnect the organization database to the system. To do this, in Deployment Manager right-click the organization and select Disable, right-click the organization again, click Edit Organization, and then change the SQL Server value in the wizard. For more information about how to edit an organization, see the Deployment Manager Help.

This scenario is a worst-case situation, that is, total failure of the computer that is running SQL Server. In other circumstances, such as the failure of a disk, you may only have to restore a single database to recover the environment.

For more information about failure recovery for SQL Server, see Disaster Recovery Planning (Database Engine).

See Also

Microsoft Dynamics CRM 2013 failure recovery
Scenario B: Microsoft Dynamics CRM Server 2013 failure

© 2016 Microsoft Corporation. All rights reserved. Copyright