locked
Duplicate Dynamics CRM 2011 database - Prod x Test RRS feed

  • Question

  • Can we securely duplicate CRM 2011 database using backup from production environment and restore to test server? (and reimporting organization using deploy manager)

    Like this tutorial http://blog.customereffective.com/blog/2008/09/best-practices.html

    Its possible to get this tasks done automatically? (ie: replicate prod database to test environment every night)

    We have 1 server with all crm roles on it, 1 server for sqlserver and other servers for AD.

    Production and test environments connect to the same AD but use different SQL servers.


    Virtual Group - Soluções Inteligentes www.virtualgroup.com.br
    Wednesday, January 11, 2012 7:06 PM

All replies

  • Hi Christophe,

    Yes you can do that, it shouldn't cause any issues.

    The easiest way to replicate the prod database to the test environment every night, is to backup and restore to the test environment without deleting the organization from the deployment manager, overwriting the existing Test database, automating this process in SQL.

    Abraços

    Nuno

     

     


    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com
    Wednesday, January 11, 2012 9:09 PM
    Answerer