How do I restore an enterprise project from a previous backup of the Project Server database? RRS feed

  • Question

  • Hello,

    Our server environment went down and in the process some project updates were lost. Is there a way I as the Server Admin, or the PMs, can restore on the server the last version of project schedules that existed before the server went down?



    Judy Washington

    Wednesday, July 10, 2013 12:49 PM


  • Judy,

    In addition to Dinesh Rai's suggestion, in your specific scenario described above,  only administrative restore option would help you restore most recent version of the project plan without impacting other project plans and  keeping previously processed actuals intact. If updates were submitted after the backup, effected resources has to recall, delete and resubmit the updates. (Deleting the timesheet is not necessary but to avoid possible corruption would be worth to do it)

    Administrative backups are not taken automatically, Project Server admin first have to define the schedule and number of copies to be kept in the Archive database. Remember depending on total number of projects and number of versions , size of Archive database will vary.

    Restoring database is more suitable candidate in case disaster recovery event,  where all 4 databases and content database has to be restored and PWA site needs to be re-provision or you need to build separate non-production environment using production data set.

    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    • Marked as answer by Judy IPD Wednesday, July 10, 2013 3:00 PM
    Wednesday, July 10, 2013 2:24 PM

All replies