Recover a project that was deleted?

S

Sandy

An incorrect project was deleted from Project Server. We tried to recover
utilizing the RestoreP utility and we're receiving an error "Project id not
found in destination database". We've utilized the RestoreP utility before
for corrupted projects. Is there something we're missing for recovering
deleted projects?
 
D

Dale Howard [MVP]

Sandy --

The RestoreP utility can only restore a project that exists in the Project
Server database, but it cannot restore a project that was deleted.
Therefore, he's how to restore it:

1. Ask your DBA to create a new SQL Server database and then restore the
backup of the Project Server database into the new database
2. Launch Microsoft Project Professional and log into Project Server
3. Click File - Open - Open from File
4. Click the ODBC button
5. Create a Machine Data Source that attaches to the new database
containing the Project Server backup and then click the Finish button and
the OK button
6. Select the new Machine Data Source and click the OK button
7. In the Import Wizard - Project Definition dialog, select the project
that was accidentally deleted and click the Finish button
8. Click File - Save As, then click the Save as File button
9. Save the project as an .mpp file
10. Close the .mpp file
11. Click Tools - Enterprise Options - Import Project to Enterprise
12. Import the .mpp file saved in step #9 above

Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We wrote the books on Project Server"
 
S

Sandy

Ok, thanks and that explains why the RestoreP utility worked in the past and
not now.... I'll give that a try.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top