For some reasons we would like to change the User Profile Service Application Database. Can somebody point the correct approach to do it.

For e.g. Current user profile service application is hosted on SQL Server A. Now we want to move all the Databases related to User Profile Service Application to SQL Server B. We have My site and content database hosted on SQL Server A and we want to keep them there.

1 Answer 1


We could not change the existing UPA database server in SharePoint server. enter image description here We suggest you back up and restore the three databases: profile database, social database, and synchronization database to SQL Server B, then create a new UPA to specify SQL server B as the database server, use three restored databases in SQL server B.

  • Thanks. Will this restore all the custom settings such as Mysite, Audience and other settings of the UPA? Jul 23, 2021 at 12:15
  • The answer is no, before upgrading the My Site Host and the personal site collections, you must upgrade the Managed Metadata service application, and then the User Profile Service application, docs.microsoft.com/en-us/SharePoint/upgrade-and-update/…
    – Julie_MSFT
    Jul 29, 2021 at 8:53
  • I am not upgrading. I just want to change the Sql server instance used by UPA. Jul 30, 2021 at 6:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.