Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is it possible to create a new user profile service application and use the exisitng the databases from a previous user profile service application? Both service applications are in the same farm.

I want to preserve profile and social data.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

I have done this more then few times on my development machine (!)

You just delete old user profile service but without checking Delete data associated with the Service Applications.

Then you create new user profile service and for Profile Database, Synchronization Database and Social Tagging Database you provide same database names. If you used default values you don't need to change anything (Profile DB, Sync DB, Social DB).

I don't see any possible issues if you are doing this on same farm and with existing databases. But again, I have tested this only on my development environment!

Addition

Here is step-by-step guide on how to recreate User Profile service with PowerShell:

And here is solution to invalid Sync DB (MSDN forums):

http://social.technet.microsoft.com/Forums/da/sharepoint2010setup/thread/ae41dcd1-28d3-4832-91b9-b4a3841aedbc

This supported the idea that the UserProfile Service Application's Sync process was indeed "jacked up". To rectify this issue, I simply did not include the switch to reference the existing sync database (in the powershell command). By doing so, a new Sync database was created. At this point, I was able to start the Profile Synchronization service on one of the SP Servers and then able to create new connections to our AD Forest. Resolved my issue and kept all of the social content and the user's profile data (the intent).

So when creating 'new' User Profile Service you can simply create new Sync DB and everything will work as expected.

share|improve this answer
    
That's exactly what I thought. I'm running into an issue where I can use the previous Profile and Social DB's but I get an error about the Synchronization DB. The error says it's not a valid sync database. I'm confused why this won't work. –  daver306 Oct 3 '11 at 18:50
    
You can create new Sync DB and after you just need to do full user profile sync. I have updated my answer. –  Vedran Rasol Oct 3 '11 at 19:14
    
Thanks, Vedran. I actually tried this approach in the mean time and it did work. The new user profile service application gets created and all the Profile and Social data is there. I ran a full sync but realized that the majority of my profiles were flagged for deletion. The MySite Clean Up job eventually ran and deleted majority of the user profiles. Fortunately this is in a dev environment but I'm confused why the profiles got deleted. –  daver306 Oct 3 '11 at 19:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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