Solved

Sharepoint

Posted on 2014-01-13
3
532 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 32

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

691 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