1) Backup your source databases.
Open SQL Server Management Studio and identify the five requireddatabases (Archive, Draft, Published, Reporting and Content):
Right click on the source databases, and select Tasks >Backup.
Save the files in a place you will be able to find them again.
Afterwards, you should have all of the databases in onelocation.
2) Restore the databases to the target environment.
Open SQL Server Management Studio in the target environment,right click on the Databases heading, and choose the option to restore thedatabase.
Go now on your test environment to Central Administration- Manage Service Applications - ProjectServer and "Create Project Web App Site"
Choose a new name for the restored database. In this case,I enter the name “PWA_Contoso_Archive.” Select the option to restore froma device, specifically the location where you have stored the source data.
3) Create a new Web Application.
In my target environment, I already have a PWA site createdat http://demo/pwa. Hence, I need to create a second Web App to host the restored PWA. Inthis case, I will create a second Web Application at http://demo:81 andthen I will put my new PWA athttp://demo:81/pwa.
Note that creating the new Web App creates a new contentdatabase to contain the Web Application data.
As a best practice, you should always create a site collectionat the root of the Web App. If you don’t you’ll run into issues whensaving from Office applications or publishing forms from InfoPath.
4) Attach the restored content database to the new Web App.
Follow the instructions here to restorethe content database to the new Web App.
5) Provision a new PWA site.
When provisioning the site, ensure two things:
6) Validate the new site.
At this point, you’ll want to take a tour of your new PWA siteto ensure that all of the data transferred.
Next, click on the Server Settings and review the Project Sites.
All the sites should be properly linked now.
Here you go restored all the PWA site using the five database backup / restore method.