This really depends on the volumes. If your DB is small, the backlog could catch up, but even though, it will never be complete. For instance, in SFDC, when a lead or contact is deleted, it is flag as deleted but remains there for about 2 weeks. If your DB had been sync'ed every 5 minutes, Marketo would have had time to "notice " these deleted records before they are gone. But after 2 weeks, they have simply vanished without notice and Marketo will raise sync errors.
Another error that you might face is that the same field might have been updated on both side. AFAIK, in such a situation, when you resync, the CRM value will win.
If the DB is not too big, instead of starting from a fresh instance (which would force you to recreate or migrate all your programs), you could do the following :
- Export all the records in Marketo, with all columns. Let's call this export BkP#1
- Delete every record in Marketo which field "SFDC type [Person]" is not empty, but paying attention to not delete them from the CRM
- Enable the sync
- In the CRM, create a field named "force update" on leads, contacts, accounts, and opportunities. Then, using a data loader in SFDC, update all the records, which will cause them to be pushed and recreated in Marketo.
- Review your duplicates in Marketo. If you find a lot of them, one of them being sync'd and the other not, then consider buying the Easy Merge service from Marketo or a licence from Leadonnance (look in the lauchpoint)
- Extract all these new records (this is BkP#2) and match them with those from BkP#1. Only for those in Bkp#2, field by field, consider if you want to keep the field value from bKp#1 or bkp#2. of you want to keep bKP#1, then reimport these values, together with the email value, to udate the data in Marketo
-Greg
.png)