none
Can't Restore RRS feed

  • Question

  • Attempting to move my Project Server 2010 install to new hardware with new server name and sql instance.

    I am using the 5 DB restore method. When I go to create the new PWA site using the same url as the old one (http://project.domain.com) I get an error saying there is already a url using that.

    The only thing I can find is that there is a site colletion in my content database called project.domain.com and has the url http://project.domain.com

    Any idea's on what i should try?

    I have attempted the Sharepoint restore, but it error's on all the databases it tries to restore.

    Tuesday, June 5, 2012 12:27 PM

Answers

  • Hi BradKW,

    If I understand correctly you restored the content DB to a web application (http://project.domain.com) and then started to provision a pwa with the four databases (Archive, Draft, Published and Reporting). Normally when you do this approach PWA picks up the old PWA instance and uses it to reprovision the PWA site. A additional question is the PWA provisioned as the root site? Or do you have http://project.domain.com/pwa ?

    Could you outline the steps you took to restore the PWA. This will give me more information on where the problem might be. SharePoint restores unfortunately won't work with Project Server.

    Here is a blog with a easy outline on the 5 db restore procedure. http://azlav.umtblog.com/2011/06/07/project-server-2010-database-restore-part-i/

    With Kind Regards,

    Robin Kruithof


    Technical Consultant EPM

    • Marked as answer by BradKW Tuesday, June 12, 2012 3:16 PM
    Wednesday, June 6, 2012 11:41 AM
  • i figured it out.

    I had to add the contentDB, export the site collections, delete the site collection, create the PWA site, then import the site collection with the same URL as the PA site, then manually fix all the Project Site URLs

    • Marked as answer by BradKW Tuesday, June 12, 2012 3:15 PM
    Tuesday, June 12, 2012 3:15 PM

All replies

  • Hi BradKW,

    If I understand correctly you restored the content DB to a web application (http://project.domain.com) and then started to provision a pwa with the four databases (Archive, Draft, Published and Reporting). Normally when you do this approach PWA picks up the old PWA instance and uses it to reprovision the PWA site. A additional question is the PWA provisioned as the root site? Or do you have http://project.domain.com/pwa ?

    Could you outline the steps you took to restore the PWA. This will give me more information on where the problem might be. SharePoint restores unfortunately won't work with Project Server.

    Here is a blog with a easy outline on the 5 db restore procedure. http://azlav.umtblog.com/2011/06/07/project-server-2010-database-restore-part-i/

    With Kind Regards,

    Robin Kruithof


    Technical Consultant EPM

    • Marked as answer by BradKW Tuesday, June 12, 2012 3:16 PM
    Wednesday, June 6, 2012 11:41 AM
  • I followed that blog almost to the letter. I could get to the point of creating the PWA site, but thats where I would get the error about a site already existed with that url.

    I got it to work. What I had to do was before I made the PWA site, export-then delete the site collection. Create the PWA site (project.domain.com) and then import the site collection into the project.domain.com/

    I still have to go in and manually enter all the site addresses for the project sites, but at least it works.

    Wednesday, June 6, 2012 1:06 PM
  • i figured it out.

    I had to add the contentDB, export the site collections, delete the site collection, create the PWA site, then import the site collection with the same URL as the PA site, then manually fix all the Project Site URLs

    • Marked as answer by BradKW Tuesday, June 12, 2012 3:15 PM
    Tuesday, June 12, 2012 3:15 PM