locked
Restore User Profile Service application in SharePoint Server RRS feed

  • Question

  • Hello

    trying to re-create UPSA using 2 of 3 DBs - but in CA, I get this: 

    A SharePoint Database named user_profile_DB already exists. You must supply another name for the new database? 

    How can I 'force' the creation using the existing DBs? 


    • Edited by JmATK Sunday, July 15, 2018 4:03 PM
    Sunday, July 15, 2018 4:02 PM

Answers

  • Hi JmATK,

    Please create User Profile service application using the following commands:

    #configuration values
    $serviceName = "User Profile Service Application"
    $poolName = "SharePoint Service Application Pool"
    $profileDbName = "SP_Test_Service_UPS_Profile"
    $socialDbName = "SP_Test_Service_UPS_Social"
    $syncDbName = "SP_Test_Service_UPS_Sync"
    
    #get service application pool
    $appPool = Get-SPServiceApplicationPool -Identity $poolName
    
    #create new service application using existing databases
    $upa = New-SPProfileServiceApplication -Name $serviceName -ApplicationPool $app
    Pool -ProfileDBName $profileDbName -SocialDBName $socialDbName -ProfileSyncDBName $syncDbName
    
    #create service proxy
    New-SPProfileServiceApplicationProxy -Name $serviceName" Proxy" -ServiceApplication $upa -DefaultProxyGroup

    Thanks,

    Wendy


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    • Marked as answer by JmATK Monday, July 16, 2018 5:49 AM
    Monday, July 16, 2018 2:56 AM

All replies

  • Hi JmATK,

    Please create User Profile service application using the following commands:

    #configuration values
    $serviceName = "User Profile Service Application"
    $poolName = "SharePoint Service Application Pool"
    $profileDbName = "SP_Test_Service_UPS_Profile"
    $socialDbName = "SP_Test_Service_UPS_Social"
    $syncDbName = "SP_Test_Service_UPS_Sync"
    
    #get service application pool
    $appPool = Get-SPServiceApplicationPool -Identity $poolName
    
    #create new service application using existing databases
    $upa = New-SPProfileServiceApplication -Name $serviceName -ApplicationPool $app
    Pool -ProfileDBName $profileDbName -SocialDBName $socialDbName -ProfileSyncDBName $syncDbName
    
    #create service proxy
    New-SPProfileServiceApplicationProxy -Name $serviceName" Proxy" -ServiceApplication $upa -DefaultProxyGroup

    Thanks,

    Wendy


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    • Marked as answer by JmATK Monday, July 16, 2018 5:49 AM
    Monday, July 16, 2018 2:56 AM
  • Hi Wendy 

    thanks - but that fails - cause an existing database (profiledb)  

    tried with restart server etc etc....  still no go.. 

    Update!! 

    OMG!!!! -  MY bad !!!! - I'm so tired !!! 

    - I had another running UPSA (just called it something very different - so it wasn't shown where It supposed to...   



    • Edited by JmATK Monday, July 16, 2018 5:49 AM
    Monday, July 16, 2018 5:05 AM