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

2

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…

0