Recover/Restore of a single project on Project Server

K

Ken Shelden

Does anyone know if you can undo the changes a user made
to a project that messed it all up, but they published it
to the server anyway.

If the changes cannot be undone, can you restore a single
project from a tape backup? Really don't want to restore
the entire database because it would negate all the other
changes that others have made.

Thanks for your help

Ken Shelden
 
G

Gary L. Chefetz

Ken:

To restore a single plan from a backup:

1) First, restore the database to a blank database on the server created for
this purpose
2) Create a DSN to the database
3) Open the project with Project using an ODBC connection to the restored
database
4) Save the file as an mpp
5) delete the messed up plan from your production database
6) Import the restored plan into the database

Note: If you have multiple instances of Project Server, you can restore the
database to a test instance and use the standard Project 2002 logon to the
database rather than the ODBC connection.

--

Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.
 
R

Robert B. Zane

Ken,

If you'd like to salvage any Documents and Issues (STS subweb data)
associated with the original published project, modify step 5 in Gary's
procedure like this:

5A) Log on to PWA as an Administrator and navigate to the Manage subwebs
page (Admin...Manage SharePoint Team Services...Manage Subwebs). Write down
the Project ID and Subweb Address of the original (now damaged) project.
5B) Delete the project using the Clean up Microsoft Project Server database
page (Admin...Clean up Microsoft Project Server database) but DO NOT check
the check box beside the "Delete the SharePoint subweb for the specified
project" option.

Once you've published the restored project (Gary's step 6), add:

7A) Log on to PWA as an Administrator and navigate to the Manage subwebs
page (Admin...Manage SharePoint Team Services...Manage Subwebs). Select the
newly published, restored project and click on the | Edit subweb address|
link.
7B) In the Edit Subweb Address -- Web Page Dialog dialog box, type the old
Project ID (from step 5A) in the New subweb name: text box (replacing the
number which corresponds to the new Project ID), then click on the Ok
button.

This process also works to keep the STS subweb data if you are required, for
any reason, to rename a project.

Hope this helps,
Rob
 
Top