How to restore a deleted project plan.

[stephen.black]

Well, learned a lesson the hard way. Restorep.exe is intended to be
used for rolling back a plan vs restoring a deleted plan per our MS
Support person. I did read in several posts here stating that you could
use the utility to restore but we corrupted our production db and ended
up having to restore from backup.

So... The question is ... If a plan is deleted by accident, is there a
way to restore the single plan without corrupting the db? I have a
stage and dev env. and was thinking that I could possibly restore the
production db to the dev env. from a date which would contain the lost
plan, then save a local copy of the plan from dev and import back into
production.

My main concern is the project ID and any other project unique
identifiers. Is it possible that importing (not restorep) the plan into
the production db could cause corruption? I am sure someone out here
has experienced this and worked around it. Suggestions would be
welcomed.

Learn from my mistake, the Y option in restorep is very bad If you
don't believe me ask one of our 2950 users who lost access for 6 hrs.

 

[Gary L. Chefetz [MVP]]

Stephen:

I think you're making this harder than it is. To restore a single project:

Restore you database backup to a blank database in SQL Server.
Create a DSN to the database
Open the Project Client, click File Open
In the File Open dialog, click the ODBC button and locate the DSN
Click open and select the Project and save it as an mpp file
Use Tools > Enterprise Options > Import Project to Enterprise to restore it
to the server

If you need to restore the WSS content, follow the instructions in the
Disaster Recovery Guide

 

[stephen.black]

Thanks Gary, I like your way much better