1

I follow this step by step http://technet.microsoft.com/en-us/library/ff681014.aspx for reset the User Profile Synchronization Service but I need the GUID of the synchronization database. I searched a lot but I didn't find anything. I need also to find the GUID of the/a service.

Thank you

Kyle Trauberman
  • 25,414
  • 13
  • 85
  • 121
cocoggu
  • 401
  • 7
  • 18

1 Answers1

3

You can use Powershell to do this the way MS describes in the Technet article or the smart way:

$syncDBType = "Microsoft.Office.Server.Administration.SynchronizationDatabase"
$upaSAType = "User Profile Service Application"
$syncDB = Get-SPDatabase | where-object {$_.Type -eq $syncDBType}
$upa = Get-SPServiceApplication | where-object {$_.TypeName -eq $upaSAType}

$syncDB.Unprovision() 
$syncDB.Status = "Offline"
$upa.ResetSynchronizationMachine()
$upa.ResetSynchronizationDatabase()  
$syncDB.Provision()  
restart-service SPTimerV4

So we actually don't look for the guid but look where the database type is the sync database type. You can find more troubleshooting gems like this on Harbars site: “Stuck on Starting”: Common Issues with SharePoint Server 2010 User Profile Synchronization

Dennis G
  • 21,405
  • 19
  • 96
  • 133
  • Thank you very much but it seems $upa is NULL when I try to call ResetSynchronizationMachine(). Any idea ? – cocoggu Jan 06 '12 at 09:47
  • Could you look at your SQL Server via Management Studio and just look at all databases and check for e.g. "Profile DB" or "Sync DB" or something like "UserProfile..."? – Dennis G Jan 06 '12 at 11:45
  • Oh god... there is right Profile DB, there is right Social DB, there is right S... but, but , but ! Where is this f****** Sync DB ?! T_T Thank you and sorry for lost time ! – cocoggu Jan 06 '12 at 13:08