We need to mount production DB's of user profile service to Dev environment. We have already restored on SQL dev.

Now our intention, how to dismount existing DB's of user profile service and then how to mount new restored Social DB, Sync DB and profile DB for exciting "user profile service" on DEV environment.

1 Answer 1


You could use this method to setup new UPS using Prod UPS Profile DB in Development:

  1. Delete the UPS and keep the databases in Development UPS;
  2. Detached the Prod UPS Profile DB from Prod SQL Server;
  3. Restore the Prod UPS Profile DB to Development SQL Server;
  4. Re-Create the UPS defined all the databases as before, for the Profile DB, use Prod UPS Profile DB;
  5. Start up the services and IIS reset etc. similar posts for your reference:


Restore User Profile Data to another farm

Here are the source

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.