Monday, October 29, 2007

Migrate Project Server 2007 from One Machine to Another Machine

Purpose of the document:
Purpose of this document is to write a process to migrate MSPS2007 from one server to another (In same domain or different domain).

Terms Used:
In this document Origination Server, is referenced to server in which MSPS2007 is installed and configured as per requirements.

In this document Destination Server, is referenced to server in which MSPS2007 is installed but not configured.

Requirements
Origination Server
1. Domain account that has administrative access to WSS (Windows SharePoint Services) or MOSS (Microsoft Office SharePoint Services)
2. Shared space available to backup databases
3. Domain account has system admin access to database server

Destination Server
1. Domain account that has administrative access to WSS (Windows SharePoint Services) or MOSS (Microsoft Office SharePoint Services)
2. Space available to restore databases in destination server
3. Domain account should have system admin access to database server

Assumptions
Origination Server
1. MSPS2007 is installed
2. Provision a brand new Project Web Access site.
3. Add the migration administrator account
4. Create a backup of the Project Web Access databases.
5. Create a resource, create a project from Project Professional 2007, and make sure the newly provisioned Project Web Access site works correctly

Destination Server
1. MSPS2007 is installed and basic functionality is tested

Backup Databases Using SharePoint Central Administration

Origination Server:
1. Login to Origination server as administrator
2. Navigate to Start » All Programs » Administrative Tools » SharePoint 3.0 Central Administration



3. The Central Administration. The URL will looks like: http://OrginationServerName:port/default.aspx.

4. Click Operations tab on the top navigation bar.

5. In the Backup and Restore section of the Operations page, click perform a Backup.

6. On the Perform a Backup - Step 1 of 2: Select Component to Backup page, select the components to backup (In this case select all four project server databases). Example: PWA_Published, PWA_Archive, PWA_Reporting, PWA_Working. As shown in figure below

7. Click on Continue to Backup options
8. On the Start Backup - Step 2 of 2: Select Backup Options page
a. Under Type of Backup make sure type of backup Full option is selected
b. Under Backup File location enter the information to where the backup files should be stored
c. Also, make sure you have enough space left on the location where backup files will be placed.
d. Click on Ok


9. Files will be backup successfully

Restore Databases Using SharePoint Central Administration

Destination Server
1. Login to Destination server as administrator
2. Navigate to Start » All Programs » Administrative Tools » SharePoint 3.0 Central Administration

3. The Central Administration. The URL will looks like: http://OrginationServerName:port/default.aspx.

4. Click Operations tab on the top navigation bar.
5. In the Backup and Restore section of the Operations page, click Restore from backup
6. On the Restore from Backup: Step 1: Select Backup File page, under Backup File Location, enter the UNC path to the backup folder, and then click OK.
7. On the Restore from Backup: Step 2: Select Backup Package to Restore page, choose the target backup package, and then click Continue Restore Process.
8. On the Restore from Backup: Step 3: Select Component to Restore page, choose the restore level, and then click Continue Restore Process.


9. On the Restore from Backup: Step 4: Select Restore Options page, select New Configuration, and then click OK in the dialog box that appears.

10. To view the restore job status on the restore status page, click Refresh.
Note: Backup and recovery may take few minutes to change the status from “Waiting for Resources”.

11. When the recovery has finished, restart Internet Information Services (IIS) to make sure that the settings are propagated to the IIS metabase.

Re-link Project Web Access
1. Navigate back to SharePoint Central administration

2. Click on SSP located on left hand lower side of pane

3. Click on Project Web Access Sites to continue

4. On Manage Project Web Access Sites page, Click on Create Project Web Access Site
Note: If you want to use the existing link then delete the old link for project web access site and then click on Create Project Web Access Site.

5. On Create Project Web Access Site page
a. Under Project Web Access Site Location
I. Select the web application to host project web access (Example Sharepoint-80)
II. Type Project Web Access Path (Example PWA1)

b. Under Administrative Account, Type the new domain account you want to be administrator to Project Web Access
c. Under Primary Database, Type the information for new database server, published database (Restored from another domain), Draft database (Restored from another domain) , Archive database (Restored from another domain)
d. Under Reporting Database, Type the information for Reporting Database (Restored from another domain)

6. Click Ok

7. To view the job status on the Manager Project Web Access Sites page, click Refresh Status.

Note: Backup and recovery so it may take few minutes to change the status from “Waiting for Resources”.

8. After few minutes or hours depending on size of database the status will change to “Provisioned

9. Reset IIS

10. Open browser and type the Project Web Access URL and verify the data from another environment