How to create a Project Server Test environment from your production environment – or – Project Server 2010 Backup and Restore

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….


Built in backup and restore facility for sharepoint does not work for Project Server

If you are getting the following a similar error message after trying to migrate/do a full backup from the central admin than you have run into a Backup/restore procedure mishandling. The solution to this problem would be a manual backup and restore of the Project Db’s as follows. If you are not familiar with this steps i…