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.
To recover from this failure, follow these steps:
- Install Windows Server 2008 and make sure that the computer is in the same domain as the Microsoft Dynamics CRM Server 2011. 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.
- Install SQL Server.
- If you have a valid backup of the master database, restore that backup.
- Restore the msdb database.
- Restore the MSCRM_CONFIG and OrganizationName_MSCRM databases.
- If Microsoft SQL Server Reporting Services and the Microsoft Dynamics CRM 2011 Connector for SQL Server Reporting Services are also installed on the instance of SQL Server, restore the ReportServer and ReportServertempDB databases.
- 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.
My above blog is based on Microsoft's Official information.
I hope this blog about 'Microsoft Dynamics CRM 2011 - Failure Recovery for Scenario: SQL Server Failure' was informative. Please feel free to leave your comments.