Event Error 5553 – failure trying to synch site”??” for ContentDB “??” WebApp “??”. Exception message was Cannot insert duplicate key row in object ‘dbo.UserMemberships’ with unique index
I ran into this problem this week after doing several site collection moves. The resolution is simple, effective, and only take a few minutes.
ststam -o preparetomove –contentdb [SQLServer:DatabaseName] –site http://sharepoint
stsadm -o deletecontentdb –url http://sharepoint –databasename [database] –databaseserver [SQLSever]
stsadm -o addcontentdb –url http://sharepoint –databasename [database] –databaseserver [SQLSever]