Project Sites not showing up on new server RRS feed

  • Question

  • Hi, We are moving our Moss and Project server over to new hardware. 

    We get everything up but there is no project sites on the new server.

    We have now located the sites under the content DB for moss. Is there a way to move it from my "moss content DB" -> to my "PWA Content DB"

    Else how can i point PWA to look for the sites under a diffrent content db.

    Hope this makes sense.



    Wednesday, September 7, 2011 7:23 AM


All replies

  • I would have a look at this - http://proj2007.blogspot.com/2008/10/steps-to-move-project-server-2007-from.html in the 1st instance.
    Ben Howard [MVP] blog | web
    Wednesday, September 7, 2011 9:46 AM
  • Thanks, i will look at this as soon as i get a chance.

    Just finished moving Exchange and now have to take on Moss and Project. CRM will gbe after that.


    Just wrote the above and then i realised this is not my CRM port...

    Going to look at that link now. Thanks
    Monday, September 12, 2011 7:16 AM
  • Ok, i am not sure if that is relevant to me...

    The Moss and PWA is restored but not the Project Sites.

    i Think for some reason the PWA Project Sites is under the Moss Content DB.

    So i guess there must be a way to move them to the PWA site or to point the Project Sites to the Moss Content DB...

    i Can see all the projects sites under the"Project Sites" web part but if i click on them i get a "The page cannot be found."

    Then also that link is for Project 2007. One of our sharepoint consultants tried to link it using the resource kit but said it did not work. Not sure why not but is it the same in project 2010?

    Monday, September 12, 2011 7:27 AM
  • Ok, i think it is more something in this direction im looking for(correct me if im wrong)


    "Use STSADM (or whatever tool you’d like) to add the content database to your new Web App."

    i Think i must run that command to point my Project site to the MOSS Content DB. What is the command?

    Monday, September 12, 2011 8:55 AM
  • Hello TheWall_RSA,

    You can add content database to a web application  using central Administartion or via STSAdm command in Sharepoint/Project server 2007.

    Stsadm -o addcontentdb -url<URL name>-databasename<database name>

    Hope that helps.


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Monday, September 12, 2011 10:26 AM
  • Hi, 

    Im still not sure how that link will help me.

    Both content DB's is added and i can see them under content DB's in sharepoint. The problem is that somehow the Project Sites was created under the wrong content DB and now i cant access them. There must be a way to map them?

    Monday, September 12, 2011 12:02 PM
  • Hi,

    You can edit the site address using PWA> Server Settings> Project workspaces. Select the project which you want to map with other web application & click on edit site address. Select the Web application listed in drop down list & Test the url & Hit OK. This is just site by site but if you are looking for relinking the bulk, You can probably use the site relinker tool.

    MSDN step by step article to move data from one server to another server, also steps to migrate the content db workspaces.


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Monday, September 12, 2011 12:25 PM
  • Ok, im starting to think that not many people had this issue before...To edit the project sites i need a working url for the pwa sites which i dont.

    Why will my pwa sites be under my moss content db?




    Monday, September 12, 2011 12:46 PM
  • Ok, think that can maybe help me...


    Where in the installation procedure do i point Project to a content DB?

    Not talking about the 4 project db's(Archive, Published and the other 2)

    Tuesday, September 13, 2011 8:55 AM
  • Hello there,

    when you install the project server 2007 & configure the web application in Sharepoint central administartion, You create a content database which holds the information of Project workspaces. You can go to Web application & see the content databases or content databases in application management.

    There is a good video which has step by step installation procedure:

    You can also download the deployment guide.

    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Tuesday, September 13, 2011 9:24 AM
  • Ok, So now i must map my PWA site to a diffrent content DB...

    i Think the command should be something like this:

    Stsadm –o addcontentdb –url http://Moss/PWA –databasename wss_content_Moss –databaseserver DBServerName

    But when i run that i get a "command line error"...


    Tuesday, September 13, 2011 9:37 AM
  • ok, this seems to be working

    This it what Amit recommended above but not sure if it can fix my issue...

    when i run it i get a error saying that "a object of this farm already have the same ID"...

    Tuesday, September 13, 2011 11:48 AM
  • Tuesday, September 13, 2011 12:05 PM
  • i am using 2010...Not sure if changing the id is my solution thaugh...

    Is there a way to backup project site so that i can restore it on my new server?

    i am getting really confused here...Does not look like anyone had the same issue in the past...

    Tuesday, September 13, 2011 12:18 PM
  • Going back to the start how did you move everything to a new server?  Unless you did a full farm restore you cannot just move across the content DB and the 4 project server DBs and expect to see /PWA working.  It isn't just a site - but an application that has lots of stuff going on in the background that doesn't just work if it is moved.  You may need to re-provision a PWA instance on this new farm to get your PWA working again.  However, you cannot do this if a /PWA site already exists.  And if it does, and has your project workspaces under it you do not want to delete it either.  Take a look at my blog posting http://blogs.msdn.com/b/brismith/archive/2007/10/24/backup-and-restore-what-are-the-options.aspx and see if any of these options help you to understnad whats happening on your farm.

    Best regards,


    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Friday, September 16, 2011 9:41 PM
  • i Created a new thread and got the answer there


    Url that i followed to fix it:http://azlav.umtblog.com/2011/06/07/project-server-2010-database-restore-part-i/

    There was a project site but had to also provision a new site.

    Dont know what went wrong the first time

    Saturday, September 17, 2011 6:41 AM