none
Project Server backup best practices RRS feed

  • Question

  • Dear Project Server users,

    Can anyone share their experience with PS backup or some best practices?
    For example, I want to know which type of backup to use (the whole farm or...)
    I guess this depends on my wishes and preferences of the system, but I would like to hear some user cases if possible.

    With best regards,
    Petar 
    • Edited by PetarB Thursday, November 24, 2016 3:00 PM Typo
    Thursday, November 24, 2016 2:59 PM

Answers

  • Hello,

    There are 2 databases associated with each of your PWA instance (only Project Server 2013).

    PWA Database to hold PWA related data and configurations.

    Web application content database to store project sites related data, i.e. all your project site registers.

    You can read below deployment technet article:

    https://technet.microsoft.com/en-us/library/ee662105.aspx

    cheers.


    Khurram Jamshed | Blog |Twitter | Linkedin

    • Marked as answer by PetarB Monday, November 28, 2016 9:50 AM
    Sunday, November 27, 2016 3:53 AM
  • hello,

    to backup Project server data, including custom fields, you can use project server OOB backup/restore functionality. its available through central admin -> PWA settings page. 

    you can go through this article to know more about built-in options to use:

    https://technet.microsoft.com/en-us/library/jj993260.aspx

    In my opinion, if you configure backup of 2 DBs (PWA DB and content DB) of your PWA, that should enable you to restore your PWA with all the data and configurations in case of disaster recovery scenario.

    there are number of good blogs/articles available to help you know how to restore PWA using database migration:

    https://pwmather.wordpress.com/2013/05/02/projectserver-2013-environment-migration-rollover-steps-powershell-ps2013-msproject-sp2013/

    in case of an individual elements of PWA, OOB backup/restore works well in situations where you need to restore older version of your project schedule and etc.

    hope this helps.


    Khurram Jamshed | Blog |Twitter | Linkedin

    • Marked as answer by PetarB Friday, November 25, 2016 8:41 AM
    Thursday, November 24, 2016 11:19 PM

All replies

  • hello,

    to backup Project server data, including custom fields, you can use project server OOB backup/restore functionality. its available through central admin -> PWA settings page. 

    you can go through this article to know more about built-in options to use:

    https://technet.microsoft.com/en-us/library/jj993260.aspx

    In my opinion, if you configure backup of 2 DBs (PWA DB and content DB) of your PWA, that should enable you to restore your PWA with all the data and configurations in case of disaster recovery scenario.

    there are number of good blogs/articles available to help you know how to restore PWA using database migration:

    https://pwmather.wordpress.com/2013/05/02/projectserver-2013-environment-migration-rollover-steps-powershell-ps2013-msproject-sp2013/

    in case of an individual elements of PWA, OOB backup/restore works well in situations where you need to restore older version of your project schedule and etc.

    hope this helps.


    Khurram Jamshed | Blog |Twitter | Linkedin

    • Marked as answer by PetarB Friday, November 25, 2016 8:41 AM
    Thursday, November 24, 2016 11:19 PM
  • Thank you very much for this info Khurram, it is very helpful.

    Can you please explain the difference between the content Db and the PWA DB? I don't really understand it. As far as I know I have all the project and PWA data in the PWA SQL DB, so i guess that all the settings data for Project Server and SharePoint are in the content database? Just thinking out loud.

    Withe best regards,
    Petar
    Friday, November 25, 2016 8:44 AM
  • Hello,

    There are 2 databases associated with each of your PWA instance (only Project Server 2013).

    PWA Database to hold PWA related data and configurations.

    Web application content database to store project sites related data, i.e. all your project site registers.

    You can read below deployment technet article:

    https://technet.microsoft.com/en-us/library/ee662105.aspx

    cheers.


    Khurram Jamshed | Blog |Twitter | Linkedin

    • Marked as answer by PetarB Monday, November 28, 2016 9:50 AM
    Sunday, November 27, 2016 3:53 AM
  • Thank you very much Khurram.
    Monday, November 28, 2016 9:05 AM