harbar.net component based software & platform hygiene
April 2012 Blog Posts

User Profile Service Application Sync Database Maintenance with the February 2012 Cumulative Update

Since the release of SharePoint Server 2010, the maintenance of the User Profile Service Application (UPA) Sync DB has been extremely problematic. I’m not talking about “standard” database maintenance tasks here, you know those routine tasks you should be performing on your environment but that seldom are implemented by those running operational service :). This is all about the Sync DB retaining data that it shouldn’t. There is quite a lot of confusion out there surrounding this topic in general and it has certainly hit a lot of customers, hard. The fundamental issue stems from the choice of the...