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

13 comments:

quanticus said...

Hi there, do you know if the databases will keep there original name. I'm asking this because in my scenario de database server stays and the projectserver shuffles. So with the backup and restoring feature I need to point to the 4 newly created databases 'before' restoring.

Hope you can help me!
Kind regards,
Amancio

gman aka Gaurav Wason said...

You can use "Re-link Project Web Access" on this blog to re-link your new project server.

waqas said...

Hi There,
I want to do the same stuff, but i perform all the steps and when i go the ssp and clcik over the Project Web Access Sites and on the next page its showed me the url which it restored but its status Failed, not provisioned. When i try to retry it then its said the Databases already in use.

basically i have 4 SSP and 4 Project workspace, so i want to restore them as it is. their are no customization over it.

gman aka Gaurav Wason said...

Waqas,

Reboot all the servers in server farm and then re-try it. It should resolve the issue.

Let me know if it worked or not.

Thanks

Gaurav

Waqas Sarwar said...

Hey Gman,

i even restart the computer but its still failed. "Failed - see the Event Log"

i created a new SSP and new Proejct Access aite and its wworking fine but the restored Project access site are not working

gman aka Gaurav Wason said...

Waqas,

I don't know if you resolved the issue of workspace or not. But this is how you can fix it.

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

Use this tool and it will fix your issue.

Let me know.

Gaurav

Antonio said...

Dear Gaurav

Congratulations for your article !

I make the steps to restore the PWA in a new server but I don't understanding what happened with the sites of the Project. Is it necessary to restore another file? Where is the file that have the web sites ?
Best regards
Tupi

gman aka Gaurav Wason said...

Antonio,

You do loose the workspace information. I am working on few different options and will let you know the best one soon.

Thanks

G

Antonio said...

Hi Gaurav

Tank’s for your attention !
I would like to show some details about the problem with the workspace:
1. The restore of PWA had success.
2. If I change the name of databases in the Web Application of PWA existent , I see all the projects and resources of the old server
3. I try to restore the SSP of the old server, because all the workspace didn’t restore in the first restore (step 1). In this case, the new server, showed 2 SSPs, the new of my installation in the new server and the old. But, the second SSP (migrated) take the web application of PWA of the first SSP. In this case, the second SSP (migrated) has a PWA web application that I had created in the installation of the PS2007 and the first SSP, has not any web application.
4. I see the properties of the PWA web application and the databases are linked with the new databases ! I try to change this and receive the following error message: “The database are in use for another application”.
5. Than, I create a new web application for the first SSP, and linked with the migrated databases. In this case, the process to create the web application abended!

Hope you can help me !
Best Regards,
Antonio

gman aka Gaurav Wason said...

Workspace are not in SSP database. It is on content database of port 80. I am working on a document on how to get sharepoint workspaces. Will publish in two three days.

Antonio said...

Hi Gaurav

Thank's a lot !
I'm waiting this post.

Best Regards
Antonio

gman aka Gaurav Wason said...

Antonio,

Here is the brief approach that worked for me

1) Connect to Project Server Databases (PWA) on Port 80
2) Create a web application on Port 81 remove content db and attach content db of port-80 of previous server (contains workspace contents)
3) Use RelinkAllWSSSites tools from resource kit
Example:
RelinkAllWSSSites.exe http://projectmadeeasy:81 http://projectmadeeasy/pwa
Thanks

Gaurav

gman aka Gaurav Wason said...

Here is the new article for moving Project server with workspaces