Solved

Setting a backup system for Dynamics CRM

Posted on 2011-09-10
3
376 Views
Last Modified: 2012-05-12
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?
0
Comment
Question by:mihaisz
  • 2
3 Comments
 
LVL 5

Expert Comment

by:TRUENEUTRAL
ID: 36593924
It sounds like you just want to refresh the data.
Have you tried backing up the production database and restoring over the test database?
0
 

Accepted Solution

by:
mihaisz earned 0 total points
ID: 36718723
I figured it out: I need to do Import Organization. Restore itself loses GUIDs etc.
So the process is:
- delete the organization on Test in Deployment Manager
- restore the Live DB over the Test DB
- run Import Organization
0
 

Author Closing Comment

by:mihaisz
ID: 36902261
I figured it out myself
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now