none
find pwa db name - can pwa db and sc db be the same? RRS feed

  • Question

  • I have a two part question

    1 -- I have a pwa that currently exists, where can i find the name of the pwa db it is associated with?

    2 -- can the pwa db and the sc that is hosting it be the same database?


    Monday, May 18, 2015 4:31 PM

Answers

  • Hi,

    The PWA db name can be found in the SharePoint Central Admin, Manage Service Applications, Project Server Service app and check the settings for your PWA instances. For each PWA you have 2 dbs: the ProjectServiceApp db and another one for the SC content.

    ProjectServiceApp db is unique and each PWA instance will have its own db. However, the content DB can host multiple SC.

    Hope this helps

    Paul

    • Marked as answer by Robert Bruns Wednesday, April 19, 2017 8:27 PM
    Monday, May 18, 2015 8:51 PM

All replies

  • Hi,

    The PWA db name can be found in the SharePoint Central Admin, Manage Service Applications, Project Server Service app and check the settings for your PWA instances. For each PWA you have 2 dbs: the ProjectServiceApp db and another one for the SC content.

    ProjectServiceApp db is unique and each PWA instance will have its own db. However, the content DB can host multiple SC.

    Hope this helps

    Paul

    • Marked as answer by Robert Bruns Wednesday, April 19, 2017 8:27 PM
    Monday, May 18, 2015 8:51 PM
  • ProjectServiceApp db is unique and each PWA instance will have its own db. However, the content DB can host multiple SC.

    The above is true for Project Server 2013.

    For versions < 2013 there were 4 databases plus the SharePoint content database

    ... and looking forward to Project Server 2016, the PWA insance data will be rolled into the SharePoint ContentDB, so per instance there will be only one DB ('to rule them all, and in the darkness bind them')

    Regards,

       James.


    James Boman BSc. MCP:EAD -

    Monday, May 18, 2015 11:46 PM
  • Hi,

      You can go to central Admin --> Manage Service Applications--> Project server service click Manage in Ribbon

    On the PWA instance name on the right you will get the drop down for Retry/Manage/Edit etc options.... you can click edit to check the PWA DB name. 

    ---------------------------------

    Please mark as answer if tip helped you resolve your issue.

    Regards,

    Faizan.


    Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS

    Tuesday, May 19, 2015 5:35 AM