Single Project backup and restore

[Surajit Laha]

Hi,

I want to backup a single project plan and its associated timesheet
entries and then would like to restore them in a different
ProjectServer.

How can I do this in MS-Project Server 2003?

Please help.

regards,

Surajit Laha

 

[Dale Howard [MVP]]

Surajit --

Do the following:

1. Launch Microsoft Project Professional and log into Project Server
2. Open the project in question
3. Click File - Save As - Save As File
4. Save the project as an .mpp file
5. Log into PWA with administrator permissions
6. Click Admin - Clean Up Project Server Database
7. Delete the project and its associated SharePoint subweb

On the new Project Server instance, do the following:

1. Launch Microsoft Project Professional and log into Project Server
2. Click Tools - Enterprise Options - Import Project to Enterprise
3. Import the project
4. Click Collaborate - Publish - All Information
5. Click Collaborate - Publish - Republish Assignments
6. Select the "Overwrite actual work entered by resources" option
7. Click OK

Hope this helps.

 

[Surajit Laha]

Hi Dale,

Thanks a lot for your answer.

It works. But the trouble is: It publishes the data in the Resource
views of the project plan (as obvious).

There are cases when the Project plan data does not actually match
with the exact Timesheet data entered by the resource!

So if I copy the plan to the other server (by Importing the plan), and
re-publish it over-writing the actual works, this new Timesheet of the
Resource would be different from the timesheet of the resource in the
first server (from where I ported).

How can I fix this problem?
What I actually want is: the MSP_WEB_WORK table entries should be the
same in both the servers.

Any help would be highly appreciated.

Regards,
Surajit Laha