Its a technical blog by pcsmitpra to discuss about ASP.NET and IIS related Tricks and Tips. Every solution given here is tested in some environment which may or may not apply to your. ****AS IS**** Please apply at your own risk.
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:
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).
$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).