Problems while opening MPP file from project server

[Sreejith]

We published some MPP files to EPM.But now we are unable
to open two of the published MPP files using Microsoft
project.While opening the system is hanging.But for other
MPP's it is working fine.We don't have a local copy of
these MPP file.So if we are unable to open the file we
are going to loose data.Please advice a mechanism to open
the published MPP file of these projects

 

[Gary L. Chefetz [MVP]]

Sreejith:

And you don't backup your SQL database? If not, you may be in an
unrecoverable situation. You might try making a simple ODBC connection to
the database and try opening the plans that way. If you can, save them off
as mpp files and try reimporting. If you can't open the plans, spend the
rest of today implementing your backup plan while your Project Managers
rebuild their project plans.