★ EPPM Solutions ★ Technology ★ Business Analysis ★ ITIL ★ ITSM ★ PMBOK ★

uB )

Custom Implementation, Services, Training & Support through Experienced, Wise Use of Available Knowledge, Facilitating Access to Relevant Information, Research and Opportunities besides hands on EPMO and EPMS Projects. Ask !

Move Project Server 2007 from One Environment to Another (Including Workspace)


1.       Installed Project Server on New Machine to a point where you have SharePoint Central Administration, Web Application on Port 80, Web Application for SSP and Project Application Service is started.

2.      Same project server service pack and patches installed on new server.

3.      Backed and restored project server database to new server.

4.      Backed and restore Content Database for Port 80 (Assuming your project server work space was on port 80)


  1. Start » All Programs » Administrative Tools » SharePoint 3.0 Central Administration
  2. Operations > Topology and Services > Services on Server > Project Application
  3. Make Sure Project Application Service is started.
  4. Under Shared Service Administration Click on SharedServices1 (Name could be different)
  5. Click on Project Web Access Sites
  6. Click on Create Project Web Access
  7. Make Sure you select the same "Project Web Access Path" if you want to RESTORE AND RELINK SharePoint workspace. My Scenario was PWA.
  8. Enter the account info for Administrator Account and Primary Database Server
  9. Enter the name of Published Database, Draft Database, Archive database and Reporting Database (restored databases)
  10. Click on refresh status after few minutes, the Site should be provisioned
  11. Click on the site just to make sure project web access is working
  12. Click on Workspace "The PAGE not found" (EXPECTED)
  13. Now Create a new web application
  14. Navigate back to central administration > application management > Under SharePoint Web Application Management Click on Create or Extend Web Application
  15. Create New Web-Application on Port 81 *Can be any port except 80
  16. Once the Web application is created on port 81 > Navigate back to central administration > application management > Under SharePoint Web Application Management Click on Content databases
  17. Change the Web-Application to http://servername:81/
  18. Remove the content database of port 81 (Make Sure you are removing the content database of correct web application)
  19. Click on Database name and then click on Remove Content Database > Click Ok
  20. Add Content Database of Port 80 from Previous Server (I did restored the database as "OLD") to this web application on Port 81
  21. Download Project Server Resource kit for project server 2007 from Microsoft.com
  22. Extract it to C:\ResourceKit
  23. Start > Run > Cmd
  24. Browse to C:\ResourceKit
  25. Type ReLinkAllWSSSites.exe http://servername:81 http://servername/pwa
  26. Type Browse to PWA (http://serverName/PWA) you should see all Projects and their SharePoint sites.

Check this blog from Brian Smith



Post a Comment

Thank you.