How to Fix the Event ID Error 5553 in SharePoint Server 2010

If you are getting an error from the source SharePoint Portal Server with Event ID 5553 on your SharePoint Serer 2010 you may need to delete the link in the Config_DB. The error may look similar to the following. failure trying to synch site dd51ad6a-e14d-4ed7-a2a7-e22992f09990 for ContentDB 00f45cc7-4f4a-44e7-8779-854375da0a81 WebApp 549868d8-17ab-4c75-9193-d2e38e7f3517.  Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The statement has been terminated.. One solution that I know is to use the STSADM tool to list the content databases that are out of sync and then delete the links. Here's how.

1. Lists content databases that have not been synchronized since n days. The presumption is that they have been deleted or moved. For example, to list the databases that have not been synchronized for 1 day type the following command: stsadm -o sync -listolddatabases 1
2. To delete old records corresponding to these out of sync databases, use the deleteolddatabases command. Don't worry, according to Microsoft, this command doesn't delete the databases themselves it only deletes the links in the configuration databases. stsadm -o sync -deleteolddatabases 1
3. You should see an Operation completed successfully message.