Retrieving mpp files

[Kristi]

Hi-

I have an mpp file that is apparently corrupt (I can't access it from
Project Server (pwa) 2007 - my computer freezes). I also can't open it by
going to Project ==> Open ==> choose the project from the server (computer
freezes).

Where does Project Server 2007 store the actual mpp file on the server?

Thanks!

Kristi

 

[Ben Howard]

Hi Kristi,
MPP files don't exist in a project server environment - everything is stored
in a SQL database. I would begin to check the event logs in the 1st instance.

 

[Kristi]

Do you have an easy way (or view) to reconstruct an mpp that may be corrupt?

Thanks!

Kristi

 

[Ben Howard]

Did you set up scheduled Archiving in Project Server 2007? this is the
easiest way, otherwise you are probably into a DR situation.

 

[Diaa Hussein - I would be glad to help]

Did you set up scheduled Archiving in Project Server 2007? this is the
easiest way, otherwise you are probably into a DR situation.
--
Thanks, Ben.http://appleparkltd.spaces.live.com/





- Show quoted text -

there is way to retrieve the data stored in the database
open the table MSP_PROJECTS
set all the the following fields to 1

PROJ_EXT_EDITED_DATE
PROJ_EXT_EDITED_DUR
PROJ_EXT_EDITED_FLAG
PROJ_EXT_EDITED_NUM
PROJ_EXT_EDITED_CODE
PROJ_EXT_EDITED_TEXT
then reopen your project
it shall retrieve all the Data stored in the database then you can
save and publish the project back

 

[mike.mahoney]

there is way to retrieve the data stored in the database
open the table MSP_PROJECTS
set all the the following fields to 1

PROJ_EXT_EDITED_DATE
PROJ_EXT_EDITED_DUR
PROJ_EXT_EDITED_FLAG
PROJ_EXT_EDITED_NUM
PROJ_EXT_EDITED_CODE
PROJ_EXT_EDITED_TEXT
then reopen your project
it shall retrieve all the Data stored in the database then you can
save and publish the project back- Hide quoted text -

- Show quoted text -

Kristi

Ben' suggestion is the way to go, however if you don't have a backup
try opening the plan from published store. If you can save over the
corrupt plan.

regards

Mike