Solved

Sharepoint

Posted on 2014-01-13
3
494 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

929 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now