<div>
It sounds like you just want to refresh the data.<br />
Have you tried backing up the production database and restoring over the test database?<br />

</div>


It sounds like you just want to refresh the data.
Have you tried backing up the production database and restoring over the test database?


<div>
<div class="content wysiwyg-content">
I have CRM installed on 2 production servers (P1 with the CRM Server and P2 with the DB). <br />
In the same network (same Active Directory) I have 2 test servers: T1 with CRM 2011 Server and T2 with the SQL DB.<br />
All servers have Windows 2008 R2 and we use SQL Server 2008 R2.<br />
<br />
I’ve imported the production CRM database to Test and it works fine.<br />
I’d like to do the same (import from time to time the production DB to Test), so in case the production servers fail, I can use the test server.<br />
Having the servers down for a few hours is not a problem.<br />
<br />
When I try to import again the production DB on the test servers, I get a message that I already imported the organization.<br />
<br />
Is there a way to re-import the same organization from time to time, thus refreshing the data I have on the test servers?<br />

</div>
</div>


I have CRM installed on 2 production servers (P1 with the CRM Server and P2 with the DB). 
In the same network (same Active Directory) I have 2 test servers: T1 with CRM 2011 Server and T2 with the SQL DB.
All servers have Windows 2008 R2 and we use SQL Server 2008 R2.

I’ve imported the production CRM database to Test and it works fine.
I’d like to do the same (import from time to time the production DB to Test), so in case the production servers fail, I can use the test server.
Having the servers down for a few hours is not a problem.

When I try to import again the production DB on the test servers, I get a message that I already imported the organization.

Is there a way to re-import the same organization from time to time, thus refreshing the data I have on the test servers?


Setting a backup system for Dynamics CRM

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.