none
I need restore a project server environment to another lab environment RRS feed

  • Question

  • Good Morning

    I have two environments one laboratory and another production, I would like to have the environment as the production lab to do some testing, implementing training etc, so I'd have both environments at the same level.
    Someone could tell me what is the best way to do this?

    I happen to get a copy of the BD production, mount the database server in laboratory and dock them in the Project Web App Site.
    I appreciate your suggestions.


    Alejandro Tabares Florez

    Thursday, February 14, 2013 12:54 PM

Answers

  • Hi Alejandro,

    1. Take SQL db backup of 4 project databases and associated content database from Production and restore it in lab environment SQL server.
    2. Provide necessary SQL permissions
    3. Connect to Lab SharePoint Central Admin
    4. Provision Project Server Service Application if you don't have one
    5. Create new Web application and temp content database
    6. Detach temp content database and attached restored content database
    7. Navigate to Application Management>>Manage Service Application and Click on Project Server Service Application
    8. Provision PWA site with same name as prod like /PWA should remain as /PWA
    9. Enter exact same database names as restored in lab SQL server

    In the future if you need to refresh again ,

    1. Delete PWA site
    2. Detach content database
    3. Delete 4 projects and 1 content database from SQL server
    4. Repeat steps 1-3 & 6 to 9


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Thursday, February 14, 2013 3:58 PM
    Moderator
  • Hello Alejandro,

    Hrishi has given you great instructions.

    I would just like to suggest one utility (Playbooks.exe) you can use to copy settings from one environment to another if you have problems DB restoring.

    Create new PWA site and copy settings from one environment to the other:

    http://technet.microsoft.com/en-us/library/gg128952%28v=office.14%29.aspx

    Saturday, February 16, 2013 12:29 PM

All replies

  • Hi Alejandro,

    1. Take SQL db backup of 4 project databases and associated content database from Production and restore it in lab environment SQL server.
    2. Provide necessary SQL permissions
    3. Connect to Lab SharePoint Central Admin
    4. Provision Project Server Service Application if you don't have one
    5. Create new Web application and temp content database
    6. Detach temp content database and attached restored content database
    7. Navigate to Application Management>>Manage Service Application and Click on Project Server Service Application
    8. Provision PWA site with same name as prod like /PWA should remain as /PWA
    9. Enter exact same database names as restored in lab SQL server

    In the future if you need to refresh again ,

    1. Delete PWA site
    2. Detach content database
    3. Delete 4 projects and 1 content database from SQL server
    4. Repeat steps 1-3 & 6 to 9


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Thursday, February 14, 2013 3:58 PM
    Moderator
  • Hello Alejandro,

    Hrishi has given you great instructions.

    I would just like to suggest one utility (Playbooks.exe) you can use to copy settings from one environment to another if you have problems DB restoring.

    Create new PWA site and copy settings from one environment to the other:

    http://technet.microsoft.com/en-us/library/gg128952%28v=office.14%29.aspx

    Saturday, February 16, 2013 12:29 PM