none
Project Server 2010 Migratet from one farm to another farm RRS feed

  • Question

  • Hi ,

    I need to migrate existing Project server 2010 farm one server to another server.

    Kindly suggest me what is the best way we need to fallow.

    Existing Environment two server:

    1.  App server(SharePoint 2010 +Project Server 2010)- Existing PWA site is running

    2.Database server(with DNS instance name)

    New Environment:

    1.App server (fresh installed SharePoint + project server 2010)

    2.DB server fresh server with sql 2008


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    Monday, May 12, 2014 6:07 AM

Answers

  • Hello, Do you need to just rollover over the Project Server side of things? Have you built a new farm on the new target server? If yes to both of these, see the steps below:

    http://pwmather.wordpress.com/2012/04/10/projectserver-2010-environment-rollover-steps-powershell-ps2010-msproject-sp2010/

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Monday, May 12, 2014 8:15 AM
    Moderator
  • Hi Paul,I have fallowed different method and achieve successfully migration from DR to production.

    Step 1-Back up the existing databases in SQL Server

    Back up all 5 Db from DR environment
    ◦Content database that contains the PWA site and Project Sites
    ◦ProjectServer_Archive
    ◦ProjectServer_Draft
    ◦ProjectServer_Published
    ◦ProjectServer_Reporting

     
    Step 2- stop the following services on new envirenemnt-

    1-World wide web publishing service
    2-Sharepoint2010 administrator
    3-Sharepoint2010 timer
    4-Share point 2010 tracing
    Note-We stop all these services because when we restore WSS_content database in sql then it not restore because here is the same name of  WSS_content in  2010 also.

    Step 3-Now restore all five databases and overwrite the existing database (WITHREPLACE)

    Step 4-Now again restart all the sharepoint2010 service

    Step 5- Add the restored content database to the new Project Server 2010 farm
    stsadm -o addcontentdb -url "http://abc/" -databasename WSS_Content -databaseserver servername
    The database name should be the exact name of the content database you restored to SQL Server in the previous procedure. When the command prompt returns, the step has been completed.
    This command will create its own content database. After run this command iisreset/noforce.


    Step 6-Provision a new Project Server 2010 PWA instance using the restored databases.
     When the instance is created, the restored databases will be upgraded to new envirenemnt Project Server 2010.

    Step 7-The Project Sites will need to be re linked using the “Bulk Update Project Sites” functionality in Server Settings on the newly provisioned  PWA site.



    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    • Proposed as answer by Brijj1 Sunday, May 25, 2014 6:25 AM
    • Marked as answer by Hasan Jamal Siddiqui Thursday, May 29, 2014 7:59 AM
    Sunday, May 25, 2014 6:22 AM

All replies

  • Hello, Do you need to just rollover over the Project Server side of things? Have you built a new farm on the new target server? If yes to both of these, see the steps below:

    http://pwmather.wordpress.com/2012/04/10/projectserver-2010-environment-rollover-steps-powershell-ps2010-msproject-sp2010/

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Monday, May 12, 2014 8:15 AM
    Moderator
  • Hi, 

    In addition to Paul's spot on blog post, which i have personally used as well, you can also see following detailed blog post to know about migration process in more depth.

    http://azlav.umtblog.com/2011/06/07/project-server-2010-database-restore-part-i/

    http://azlav.umtblog.com/2011/06/09/project-server-2010-database-restore-part-ii/

    basically its about moving your 5db dataset from 1 environment to another using either powerShell (recommended) or central admin options.

    hope this helps.


    Khurram Jamshed - MBA, PMP, MCTS, MCITP ( Blog, Twitter, Linkedin )
    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.

    Monday, May 12, 2014 8:22 AM
  • Thanks Paul,

    Can i use Farm backup and restoration.


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    Monday, May 12, 2014 5:01 PM
  • Thanks Jamshed,

    Can i use Farm backup and restoration.


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    Monday, May 12, 2014 5:05 PM
  • Thanks Paul,

    Just i need one confirmation, which method is best.

    Farm backup or DB restoration.

    i feel farm back process is very small  step is required,because my new environment is fresh nothing is configure there.

    Please suggest.


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    Monday, May 12, 2014 7:18 PM
  • Hi Hasan,

    if you need to move your PWA from 1 instance (say test instance) to another instance (say production instance), then feel free to use 5DB set migration process ( you can use steps mentioned in Paul's blog post OR the steps in blog post i have mentioned above in my previous reply).

    hope this helps.



    Khurram Jamshed - MBA, PMP, MCTS, MCITP ( Blog, Twitter, Linkedin )
    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.

    Monday, May 12, 2014 7:31 PM
  • It depends what you are comfortable with. Have a trial migration and see if the option works for you. Either way, I would recommend a trial migration first then full UAT.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Monday, May 12, 2014 7:33 PM
    Moderator
  • Hi Paul,

    Sorry for unmask answer,Now i am doing same work on my environment i got error on below point


    PS C:\Users\abc> Mount-SPContentDatabase "Project_WSS_Content" -DatabaseServ
    er "abcDB" -WebApplication "http://abc/"
    Mount-SPContentDatabase : This content database has a schema version which is n
    ot supported in this farm.
    At line:1 char:24
    + Mount-SPContentDatabase <<<<  "Project_WSS_Content" -DatabaseServer "WF0EPMDB
    " -WebApplication "http://abc/"
        + CategoryInfo          : InvalidData: (Microsoft.Share...ContentDatabase:
       SPCmdletMountContentDatabase) [Mount-SPContentDatabase], SPUpgradeExceptio
      n
        + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletMountCon
       tentDatabase


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS


    Thursday, May 22, 2014 1:53 PM
  • What patch level / version is the source farm and what patch level / version is the target farm? You wont be able to restore databases from a farm with Service Pack1 installed to a farm that is only RTM etc.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Thursday, May 22, 2014 2:31 PM
    Moderator
  • Hi Paul after patch update.

    problem has been resolved,now new isse

    when esecuting

    New-SPProjectWebInstance -Url “<web application URL + PWA path>” -AdminAccount “<Project Server Administrator account> -PrimaryDbserver “<Test / Dev SQL Server>” -PublishedDbname “<ProjectServer Published database>” -ArchiveDbname “<ProjectServer Archive database>” -DraftDbname “<ProjectServer Draft database>” -ReportingDbserver “<Test / Dev Reporting SQL Server>” -ReportingDbname “<ProjectServer Reporting database>”

    command:

    PS C:\abc> New-SPProjectWebInstance -Url "http://abc/PWA" -Adm
    inAccount "abc/12ab" -PrimaryDbserver "abcdb"  -PublishedDbname
     "ProjectServer_Published" -ArchiveDbname "ProjectServer_Archive" -DraftDbname "
    ProjectServer_Draft" -ReportingDbserver "abcdb" -ReportingDbname "ProjectS
    erver_Reporting"
    Creation of PWA site queued

    PS C:\User\7> Get-SPProjectWebInstance -URL http://abc/PWA | Sele
    ct ProvisioningStatus

    ProvisioningStatus
    ------------------
    InProgressProvisioningDbs


    PS C:\Users\7> Get-SPProjectWebInstance -URL http://abc/PWA | Sele
    ct ProvisioningStatus

    ProvisioningStatus
    ------------------
    Failed

    I am using right acount


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS



    • Edited by Hasan Jamal Siddiqui Friday, May 23, 2014 12:54 PM
    • Proposed as answer by Brijj1 Sunday, May 25, 2014 6:26 AM
    • Unproposed as answer by Brijj1 Sunday, May 25, 2014 6:26 AM
    Friday, May 23, 2014 11:45 AM
  • Event viewer Error:

    Failed to provision site PWA with error: Microsoft.Office.Project.Server.Administration.ProvisionException: Membership synchronization failed. ---> System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
       at Microsoft.SharePoint.Library.SPRequest.RemoveRoleDef(String bstrUrl, Int32 lRoleID)
       at Microsoft.SharePoint.SPRoleDefinitionCollection.Delete(SPRoleDefinition roleDefinition)
       at Microsoft.Office.Project.Server.BusinessLayer.SharePointSecurityHelper.DeleteRoleByName(SPWeb web, String roleName)
       at Microsoft.Office.Project.Server.BusinessLayer.SharePointSecurityHelper.DeleteRoles(SPWeb web)
       at Microsoft.Office.Project.Server.BusinessLayer.SharePointSecurityHelper.ConfigureDefaultPWAWSSSecurityModel(SPSite topSite, SPWeb web)
       at Microsoft.Office.Project.Server.BusinessLayer.Admin.<>c__DisplayClass18.<QueueUpdateUsersAddRemoveStatusOnPwaRootsAndWorkspaces>b__17()
       at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()
       at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
       at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
       at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
       at Microsoft.Office.Project.Server.BusinessLayer.Admin.QueueUpdateUsersAddRemoveStatusOnPwaRootsAndWorkspaces(Dictionary`2 deletedUserUidsLoginNames, Guid[] addedUserUids, Boolean isFullSync, Boolean syncWorkspaces)
       at Microsoft.Office.Project.Server.BusinessLayer.Admin.SynchronizeMembershipForPwaAppRootSite()
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.SynchronizePwaMembership(ProjectProvisionSettings provset, ProjectSite projectSite)
       --- End of inner exception stack trace ---
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.SynchronizePwaMembership(ProjectProvisionSettings provset, ProjectSite projectSite)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    Friday, May 23, 2014 2:03 PM
  • Hi Paul,I have fallowed different method and achieve successfully migration from DR to production.

    Step 1-Back up the existing databases in SQL Server

    Back up all 5 Db from DR environment
    ◦Content database that contains the PWA site and Project Sites
    ◦ProjectServer_Archive
    ◦ProjectServer_Draft
    ◦ProjectServer_Published
    ◦ProjectServer_Reporting

     
    Step 2- stop the following services on new envirenemnt-

    1-World wide web publishing service
    2-Sharepoint2010 administrator
    3-Sharepoint2010 timer
    4-Share point 2010 tracing
    Note-We stop all these services because when we restore WSS_content database in sql then it not restore because here is the same name of  WSS_content in  2010 also.

    Step 3-Now restore all five databases and overwrite the existing database (WITHREPLACE)

    Step 4-Now again restart all the sharepoint2010 service

    Step 5- Add the restored content database to the new Project Server 2010 farm
    stsadm -o addcontentdb -url "http://abc/" -databasename WSS_Content -databaseserver servername
    The database name should be the exact name of the content database you restored to SQL Server in the previous procedure. When the command prompt returns, the step has been completed.
    This command will create its own content database. After run this command iisreset/noforce.


    Step 6-Provision a new Project Server 2010 PWA instance using the restored databases.
     When the instance is created, the restored databases will be upgraded to new envirenemnt Project Server 2010.

    Step 7-The Project Sites will need to be re linked using the “Bulk Update Project Sites” functionality in Server Settings on the newly provisioned  PWA site.



    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    • Proposed as answer by Brijj1 Sunday, May 25, 2014 6:25 AM
    • Marked as answer by Hasan Jamal Siddiqui Thursday, May 29, 2014 7:59 AM
    Sunday, May 25, 2014 6:22 AM