none
Project Server 2007 - PWA Instance & Sub Site Back up RRS feed

  • Question

  • Hi,

    I am using Project Server 2007. Having a requirement of moving an existing PWA instances to a new server.We have 3 subsites under each PWA instance.So want to know which is the best way for taking back up of PWA site & sub site.

    Thanks in Advance

    Anju


    -Anju

    Friday, January 10, 2014 8:57 AM

Answers

  • Just backup and restore content databases and project server on the new SQL server.  Create a site collection using content database and provision PWA and point to the restore databases.  It should be basically the same instructions for a new PWA instance, you are just referring to the databases restored.   If you point to existing databases it will then use them versus creating new dbs.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by Anju S Monday, January 13, 2014 5:28 AM
    Saturday, January 11, 2014 11:58 PM
    Moderator
  • No, you need to re-register the event handler


    Hrishi Deshpande Senior Consultant

    • Marked as answer by Anju S Monday, January 13, 2014 5:39 AM
    Monday, January 13, 2014 5:30 AM
    Moderator

All replies

  • What do you mean by sub site , are you referring to Project workspace site? If yes , here is the KB which might help you

    http://support.microsoft.com/kb/963124/en-us


    Hrishi Deshpande Senior Consultant

    Friday, January 10, 2014 5:46 PM
    Moderator
  • Just backup and restore content databases and project server on the new SQL server.  Create a site collection using content database and provision PWA and point to the restore databases.  It should be basically the same instructions for a new PWA instance, you are just referring to the databases restored.   If you point to existing databases it will then use them versus creating new dbs.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by Anju S Monday, January 13, 2014 5:28 AM
    Saturday, January 11, 2014 11:58 PM
    Moderator
  • Thanks for your reply.It solves my problem.But need a confirmation as well. If i just copy the DB (leaving the content) will the event handler attached to timesheet also will be carried to the new environment.I may have to copy the custom DLL associated to event handler in the new server, but apart from that will other settings associated to the event handler be copied?


    -Anju

    Monday, January 13, 2014 5:28 AM
  • No, you need to re-register the event handler


    Hrishi Deshpande Senior Consultant

    • Marked as answer by Anju S Monday, January 13, 2014 5:39 AM
    Monday, January 13, 2014 5:30 AM
    Moderator