Answered PWA - Import/Restore Project Server Backup Data

  • 30 ตุลาคม 2552 11:35
     
     

    How to import the project server data. We have "Archive Project.bak", "Draft Project.bak", "Published Project.bak" and "repoting Project.bak" file. And I installed and created a new PWA site (http://server/pwa). 

    Please help me to import/restore the above project backup data.

    Thanking You.  

ตอบทั้งหมด

  • 30 ตุลาคม 2552 15:31
    เจ้าของ
     
     คำตอบ
    Hi Arkay,

    I'm assuming this is not a 2010 question but a 2007 one?  The answer will be different.  For 2007, assuming you do not care about any WSS data you may have in Project Workspace you can just restore your SQL Server backups and then provision a new PWA site naming these backups.  You should not create the PWA first and then restore the DBs.  So if you want to use http://server/pwa you should frst delete this site.

    For 2010 the answer is different as we are making much more use of SharePoint for storage of entities used by each Project instance.  This is in addition to the Project Sites (new name for Workspaces).  Therefore 2010 will always require 5 databases to provision existing data to a new server - the content DB (or potentially a subset of it) and the 4 Project Server DBs.

    Hope this helps.  The are also 2007 newsgroups where questions such as these may already have been answered.

    Best regards,

    Brian Smith [MSFT]
  • 14 พฤศจิกายน 2552 21:35
     
     

    I posted a similar question in the Project Server 2010 forum, however, you may answer this.

    Is it required to have the SharePoint content database?  I was under the impression that you could do a migration without the SharePoint and just use the 4 project server databases.

    Also, is the infrastructure upgrade required after SP2?

    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MDCBA

  • 16 พฤศจิกายน 2552 9:18
    เจ้าของ
     
     
    no the content DB is not required. See my other reply on the Project Server Forum
  • 16 พฤศจิกายน 2552 22:44
    เจ้าของ
     
     
    For 2007 to 2010 the Content DB is not required as Christophe mentions - but be aware that this will be the last time that will be true.  For any 2010 transfer between instances or servers you will require 4 Project Databases and also the Content Database - or at least the parts containing Project stuff.