Sharepoint

Why is the size of my SharePoint 2010 User Profile Service sync database so large? Can I shrink it?
WPincusITAsked:
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.Update()  
 $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).
0
 
Jamie McAllister MVPSharePoint ConsultantCommented:
0
 
Justin SmithSr. System EngineerCommented:
What I posted above is the recommended procedure and only supported fix for the issue (since Feb 2012).
0
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.