Regularly Refreshed Training Environment RRS feed

  • Question

  • We are in the process of implementing Project Server 2010 and would like to create a training environment that is refreshed weekly from the production environment in the same instance of SharePoint/Project Server. We are trying to avoid additional license fees for an additional server

    Any thoughts or suggestions are greatly appreciated!

    Jay W. Ahearn, PMP, CSM
    Monday, January 23, 2012 9:13 PM


All replies

  • Hi there,

    Why don't you just create a Training PWA instance on the same Production Project Server farm? Only limitation I can think of by having training on the same farm is that you couldn't do the 5 DB restore as the content DB can only exist once in a farm as the site GUIDs are the same so other web application can't see the sites. So that leaves you with 2 options, a 4 db restore or running a playbooks export of the Production config when you make a change then import into the Training instance (or manually apply the config changes to Training). This wouldn't take the Production project data though (not sure you would want that for training purposes though..)

    Here is a link on the DB restore process:


    Here is a link on playbooks:


    Here is an article on multiple PWA instances:




    Paul Mather | Twitter | http://pwmather.wordpress.com
    Monday, January 23, 2012 10:47 PM
  • I agree with Mathew.  Copy your production database and create a test database. Provision a training database, modify as needed for trainnig and then backup the databases.   Each time you need a new environment, restore from a backup.


    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA, MCC 2011
    Tuesday, January 24, 2012 3:51 AM
  • Paul,


    Thanks for your response! I'll do some testing over the next couple of weeks to see which solution will work best.



    Jay W. Ahearn, PMP, CSM
    Tuesday, January 24, 2012 1:50 PM
  • Is this the same Jay Ahearn that was CIO at the Breakers Resort in Florida?
    Friday, October 26, 2012 9:04 PM