Recovering Deleted Enterprise Plan from Backup

[Christine Flora]

Hi,

I'm sure this is a very rudimentary question, but I've accidently deleted a
project while in PWA. I have good backups, am well versed in restoration of
SQL Server DBs (tho I am an intermediate novice at MSP EPM and WSS) and have
read the Disaster Recovery Guide, but am still having trouble with what
exactly is involved in getting this one project plan back. We are using
WSS as well, though chances are there was nothing on the site to "recover".

First question... can anyone help simplify the recovery of the project plan?
I have downloaded the restorep utility.

Second question... Say I want to recover the plan, but not the contents of
the WSS site though still have a site (albeit empty) for the project. How
would I do that? Do I still need to recover / migrate the site from the
backup or could I recreate the project plan, thus creating the site, then
just re-delete the site and restore the old plan?

Third Question... I have Virtual Server and would like to test this in that
environment before subjecting my production environment to my bumbling.
However, my deployment is on two servers (one SQL Server, the other Project
Server and WSS) while I currently only have on vhd on my virtual server
environment. Is it possible to re-deploy the installation on the single
server (VS) without alot of hoop jumping?

Thanks SOOO much!!

Christine Flora

 

[Syamal]

Hi Christine,

I am also like you a novice in MS-EPM and had almost similar problem.
Differences are my project data got corrupted and no more viewable in Project
Pro (but available in PWA) and we do not use WSS. Still I thought that my
experience may help, before you get some expert’s suggestion.

These are the steps I followed to retrieve the project data from the backup.
1. Delete the corrupted project (used PWA’s > Admin > Manage enterprise
features ....)
2. Restore the backup of Project database into a new “test†database, in the
same database server.
3. Unzipped the files in “restorp†– we have one SQL file and another
Application file
4. In Query analyzer, I ran the SQL – this creates one important Stored
Procedure that would be needed by the “restore†application.
5. In command mode (Start > run > cmd), place your location (by CD etc.)
where “restorep†application is available. Then follow the instruction by
putting restorep/? in the command line. I put following command for my
project: restorep.exe -s prjdbpr01 -e -f test -d ProjectServer -i 198 -n
'Operations - Delivery Center Manila - Product Support' –y (see new database
“testâ€, existing project database “ProjectServerâ€, Corrupted Project’s ID
“198†and my corrupted/deleted project “Operations – Deliver ….†– change
these names, as required for you)
6. Now, this will restore the deleted project into your normal project
database.
7. You need to “Republish†the project now. (I tried “Publish all†and
“Publish new/changed†– didn’t work)
8. Since we had past time data in that project (you can now see the old time
in Project Pro), but none would be seen in PWA.
9. So, select the tasks and “Republish†them, by selecting “Overwriteâ€
option. By “Overwriteâ€, time data in Project would be available in Project
Server and would be viewable in PWA.

With that, we lost few data, time data that was entered by users between the
backup and deletion of the corrupted project.

Hope this would help, though it probably was simple as we do not use WSS.