Solved

Sharepoint

Posted on 2014-01-13
3
517 Views
Last Modified: 2014-01-14
Why is the size of my SharePoint 2010 User Profile Service sync database so large? Can I shrink it?
0
Comment
Question by:WPincusIT
  • 2
3 Comments
 
LVL 31

Expert Comment

by:Jamie McAllister MVP
ID: 39778644
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 39779172
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
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39779179
What I posted above is the recommended procedure and only supported fix for the issue (since Feb 2012).
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question