Recover a Project Server 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

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://///
    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

    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 files\common files\microsoft shared\web server extensions\12\bin
    stsadm -o enumsubwebs -url http:/// > c:\sites.txt

    Notes
        The placeholder is the name of the server that is running Project Server 2007, and the placeholder is the instance name for Project Web Access.
        The "stsadm" command saves the Sites.txt file to the root directory of drive C.
    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:////" -filename "c:\\" -nofilecompression -includeusersecurity -versions 4

    Note The placeholder is the name of the server that is running Project Server 2007. The placeholder is the instance name for Project Web Access. The placeholder is the name of the workspace, and the placeholder is name of the directory in which you want to save a backup of the workspace.
    On the File menu, click Save As, name the file Export.bat, and then save the file as a text file to the following directory:

    drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin

    Note The placeholder is the instance name for Project Web Access.
    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:////" -filename "c:\\" -nofilecompression -includeusersecurity

    Note The placeholder is the name of the server that is running Project Server 2007. The placeholder is the instance name for Project Web Access. The placeholder is the name of the workspace, and the placeholder is name of the directory where the backup file for the workspace is located.
    On the File menu, click Save As, name the file Import.bat, and then save the file as a text file to the following directory:

    drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin

    Note The placeholder is the instance name for Project Web Access.
    Run the Export.bat file. This may take a long time if there are many workspaces.
    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."
    Provision a new Project Web Access site by using the same instance name and databases.
    Browse the Project Web Access site to make sure that the site is functional.
    Run the Import.bat file. This may take a long time if there are many workspaces.
    Check the functionality of the project workspaces.

Method 2: The Project Web Access site cannot be accessed or has moved from one server to another
Note Before you follow these steps, make sure that the Project Web Access path does not exist in "Define Managed Paths" in SharePoint Central Administration.

    Restore the most recent backup of the content database by using a new instance name for the server that is running Microsoft SQL Server.
    Create a new Web Application on port 1.
    In SharePoint Central Administration and then on the server that is running SQL Server, delete the content database that was created in step 2.
    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 files\common files\microsoft shared\web server extensions\12\bin
    stsadm -o addcontentdb -url http://:1 -databasename

    Note The placeholder is the name of the server that is running Project Server 2007, and the placeholder is the name of the content database. In SharePoint Central Administration, verify that the content database is attached as expected.
    At a command prompt, type the following commands.
    Note Press ENTER after each command.

    cd \program files\common files\microsoft shared\web server extensions\12\bin
    stsadm -o enumsubwebs -url http://:/ > c:\sites.txt

    Notes
        The place holder is the port where the site resides. In this sample, the site is created on port 1.
        The placeholder is the name of the server that is running Project Server 2007, and the placeholder is the instance name for Project Web Access.
        The "stsadm" command will save the Sites.txt file to the root directory of drive C.
    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:////" -filename "c:\\" -nofilecompression -includeusersecurity -versions 4

    Note The placeholder is the name of the server that is running Project Server 2007. The placeholder is the instance name for Project Web Access. The placeholder is the name of the workspace, and the placeholder is name of the directory where you want to save a backup of the workspace.
    On the File menu, click Save As, name the file Export.bat, and then save the file as a text file to the following directory:

    drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin

    Note The placeholder is the instance name for Project Web Access.
    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:////" -filename "c:\\" -nofilecompression -includeusersecurity

    Note The placeholder is the name of the server that is running Project Server 2007. The placeholder is the instance name for Project Web Access. The placeholder is the name of the workspace, and the placeholder is name of the directory where the backup file for the workspace is located.
    On the File menu, click Save As, name the file Import.bat, and then save the file as a text file to the following directory:

    drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin

    Note The placeholder is the instance name for Project Web Access.
    Run the Export.bat file. This may take a long time if there are many workspaces.
    Provision a new Project Web Access site by using the same instance name and databases. Or, use a new instance name with the databases.
    Browse the Project Web Access site to make sure that the site is functional.
    Run the Import.bat file. This may take a long time if there are many workspaces.
    Check the functionality of the project workspaces.
    Note If the project workspaces are not linked, you must run the Project Workspace Site Relinker tool. For more information, visit the following Microsoft TechNet Web site:

    http://technet.microsoft.com/en-us/library/cc197498.aspx

    (http://technet.microsoft.com/en-us/library/cc197498.aspx)
    Delete the temporary Web application in SharePoint Central Administration, and then use Internet Information Services (IIS) to verify that it was removed.
    Delete the restored content database on the server that is running SQL Server.

Method 3: You selectively replace project workspaces

    Restore the most recent backup of the content database by using a new instance name for the server that is running Microsoft SQL Server.
    Create a new Web Application on port 1.
    In SharePoint Central Administration and then on the server that is running SQL Server, delete the content database that was created in step 2.
    At the command prompt on the server that is running Windows SharePoint Services, type the following commands, and then press ENTER after each command:

    cd \program files\common files\microsoft shared\web server extensions\12\bin
    stsadm -o addcontentdb -url http://:1 -databasename

    Note The placeholder is the name of the server that is running Project Server 2007, and the placeholder is the name of the Project Server database. In SharePoint Central Administration, verify that the content database is attached as expected.
    Obtain the URL of the project workspace that you must replace.
    At a command prompt, type the following command, and then press ENTER to export the source project workspace to a local file:

    stsadm -o export -url "http://:1//" -filename "c:\\" -nofilecompression -includeusersecurity -versions 4

    Note The placeholder is the name of the server that is running Project Server 2007, the placeholder is the instance name for Project Web Access, and the placeholder is the name of the project workspace.
    Delete the old project workspace. To do this, open Project Web Access, and then click Project Workspaces on the Server Settings menu.
    At a command prompt, type the following command, and then press ENTER to import the project workspace from the local file:

    stsadm -o import -url "http:////" -filename "c:\\" -nofilecompression -includeusersecurity

    Note The placeholder is the name of the server that is running Project Server 2007. The placeholder is the instance name for Project Web Access. The placeholder is the name of the project workspace, and the placeholder is name of the directory where the backup file for the workspace is located.