Clean Up Event ID 7888 and 5553.

see the error at your event viewer ?

 

 

failure trying to synch site 51d6d8b3-9ee0-4af3-af2f-fa5f78cc9651 for ContentDB 840eac13-c23e-4123-9fa2-9d2975d0ff13 WebApp 53ea7eb2-ec0f-4250-9d87-1550224223b8.  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..

 

 

Solution here:

http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/11af8a85-0fca-466d-beac-d29d03297edf

 

solution summary :

 

• Run 'stsadm- o preparetomove -Site <http://whatevertheguiltysiteis/> -OldContentDb <GUID of the contentdb listed in event log error>'
• Run 'stsadm -o sync -deleteolddatabases 0'

FQA:

• How do i know which site is it by GUID ?

-- QUERY#1 Run this against your config database, this will give you the content database name

SELECT *
FROM [SharePoint_Config].[dbo].[Objects]
WHERE ID='<Content DB Id from error msg>'

--QUERY#2
-- Run followign queries against the database name returned by the QUERY#1

SELECT [FullUrl]
  ,[Id]
  ,[RootWebId]
 FROM [WSS_Content_##_03].[dbo].[Sites]
WHERE ID='<Site ID from event log message>'

or you can run the query at sitemap table at the config database , then you will see all the site under this content db , then manually go to find out on the Path column of the site URL.

SELECT [Id]

      ,[ApplicationId]


      ,[DatabaseId]


      ,[Path]


      ,[Pairing]


      ,[Status]


      ,[Version]


      ,[RedirectUrl]


      ,[HostHeaderIsSiteName]


  FROM [MOSS_CONFIG_DB].[dbo].[SiteMap]


where [DatabaseId]='<Content DB Id from error msg>'