Why is the size of my SharePoint 2010 User Profile Service sync database so large? Can I shrink it?
Who is Participating?
Justin SmithConnect With a Mentor Sr. System EngineerCommented:
There are new stored procedures in the Feb 2012 cumulative update that will keep the size under control.  If you have that patch installed you can run the following:

$timerJob = (Get-SPTimerJob | ? { $_.TypeName -eq "Microsoft.Office.Server.UserProfiles.UserProfileImportJob" })
 $timerJob.KeepHistoryInterval = 1  
 $timerJob | Start-SPTimerJob

Adjust the KeepHistoryInterval to your liking.  It tells the Sync database how many days of sync history to keep (which is what makes the database grow and grow).
Jamie McAllister MVPSharePoint ConsultantCommented:
Justin SmithSr. System EngineerCommented:
What I posted above is the recommended procedure and only supported fix for the issue (since Feb 2012).
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.