How to recover a Project Server 2007 project workspace when problems occur after you move a Project Web Access site or you try to recover a server that is hosting a Project Web Access site

reposted from technet

This article describes several methods that you can use to recover a project workspace site when the problems that are mentioned in this "Summary" occur.
Project workspaces are saved in a content database for the Web application that hosts the Project Web Access site. If a Project Web Access site is unavailable, or if it has to be recreated by using the Project Server databases because a full-farm backup has not been created, you may have to move the project workspaces from the content database for the Web Application to another content database for the Web Application in order to restore the links and functionality of the project workspaces.
You may encounter problems when, as an administrator, you move a Project Web Access site, or you try to recover a server that is hosting a Project Web Access site. Problems that you may encounter when you do this include the following:

• A project workspace link is broken.
• A project workspace does not exist.
• A Project Web Access site cannot be accessed.

Additionally, when you try as a user to browse to the URL of a Microsoft Office Project Server 2007 project workspace, or you click the link to a project workspace in a Project Web Access site, you receive the following error message:

To resolve these problems, use one of the following methods, as appropriate for your situation:

• If the Project Web Access site can be accessed and must be re-provisioned, use Method 1.
• If the Project Web Access site cannot be accessed or has moved from one server to another, use Method 2.
• If you selectively replace project workspaces, use Method 3.

Notes

• Before you use one of the following methods, create a new backup of any Project Server database and of any SharePoint database that is needed for the project workspace or for the Project Web Access site.
• If a project workspace has a subsite, the subsite has to be manually recreated before you run the Import.bat file. For example, the following URL is for a project workspace subsite:

  http://<ServerName>/<PWASite>/<ProjectWorkSpace>/<ProjectWorkSpaceSubSite>

• Use quotation marks (" ") around any project workspace URL or file name that contains spaces. If you do not use the quotation marks, any text that occurs after a space in the URL or file name is omitted, and the export or import commands do not finish as expected.

Method 1: The Project Web Access site can be accessed and must be re-provisioned

1. At the command prompt on the server that is running Microsoft Windows SharePoint Services, type the following commands, and then press ENTER after each command:

   cd program filescommon filesmicrosoft sharedweb server extensions12bin
   stsadm -o enumsubwebs -url http://<servername>/<pwainstancename> > c:sites.txt

   Notes

   • The <servername> placeholder is the name of the server that is running Project Server 2007, and the <pwainstancename> placeholder is the instance name for Project Web Access.
   • The "stsadm" command saves the Sites.txt file to the root directory of drive C.
2. Open the Sites.txt file in Notepad, and then make the changes as appropriate for the EXPORT command for your Project Web Access workspace. The following is an example of the EXPORT command:

   stsadm -o export -url "http://<servername>/<pwainstancename>/<workspacename>" -filename "c:<backupdir><workspacename>" -nofilecompression -includeusersecurity -versions 4

   Note The <servername> placeholder is the name of the server that is running Project Server 2007. The <pwainstancename> placeholder is the instance name for Project Web Access. The <workspacename> placeholder is the name of the workspace, and the <backupdir> placeholder is name of the directory in which you want to save a backup of the workspace.

3. On the File menu, click Save As, name the file Export<pwainstancename>.bat, and then save the file as a text file to the following directory:

   drive:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12Bin

   Note The <pwainstancename> placeholder is the instance name for Project Web Access.

4. Change the EXPORT command in the Sites.txt file to an IMPORT command. The following is an example of the IMPORT command:

   stsadm -o import -url "http://<servername>/<pwainstancename>/<workspacename>" -filename "c:<backupdir><workspacename>" -nofilecompression -includeusersecurity

   Note The <servername> placeholder is the name of the server that is running Project Server 2007. The <pwainstancename> placeholder is the instance name for Project Web Access. The <workspacename> placeholder is the name of the workspace, and the <backupdir> placeholder is name of the directory where the backup file for the workspace is located.

5. On the File menu, click Save As, name the file Import<pwainstancename>.bat, and then save the file as a text file to the following directory:

   drive:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12Bin

   Note The <pwainstancename> placeholder is the instance name for Project Web Access.

6. Run the Export<pwainstancename>.bat file. This may take a long time if there are many workspaces.
7. In SharePoint Central Administration, delete the Project Web Access site. To make sure that the Project Web Access site is deleted, monitor "Define Managed Paths."
8. Provision a new Project Web Access site b