none
How to attach a Workspace site to a restored project? RRS feed

  • Question

  • Hello,

    What is the process to attach a Workspace site (its old own workspace) to a project which has been restored from the Archive database?

    Thanks

     

    Sunday, July 25, 2010 3:31 PM

Answers

All replies

  • I believe its Project server 2007 Environment.

    -I assumed you deleted the workspace also when you deleted the project plan.

         -Need to restore the old workspace from the content database backup. (Restore SQL backup, attach the DB on different server, export the workspace)

         -Import the workspace backup on the current PWA site collection.

         -In PWA-> Server Settings->Project workspaces->Link the Plan with workspace

    -The PWS should be there if you dont delete the PWS along with project deletion (You can find in PWA root site in default path setup), In that case you can link it simply

     


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    • Marked as answer by WLID1966 Sunday, July 25, 2010 9:04 PM
    • Unmarked as answer by WLID1966 Monday, July 26, 2010 2:45 PM
    Sunday, July 25, 2010 6:07 PM
    Moderator
  • Thanks Sriram,

    Yes, it was Project server 2007 Environment!

    Sunday, July 25, 2010 9:04 PM
  • Sriram,

    One more question : When you are saying "Restore SQL backup, attach the DB on different server, export the workspace", could you explict the process to "export the workspace" ?

    Thanks again

    Monday, July 26, 2010 2:49 PM
  • could you exp

    ... could you explicate...  ;-)

    Monday, July 26, 2010 2:52 PM
  • Restore SQL database from backup

    Attach the database on different Project server 2007 environment (to avoid site collection ID conflict)

    Export the workspace using the STSADM

    stsadm -o export -url http://servername/workspacename - filename d:\sitebackup\site.bak -nofilecompression -includeusersecurity

    More Info:  http://support.microsoft.com/kb/963124


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Monday, July 26, 2010 5:22 PM
    Moderator