06-03-2009 09:31 AM
I have a user who's notes are not syncing with the database. I am using a database to database replication. This has been working in the past and has stopped working a few weeks ago.
1> Removed all temp files (actdiag)
2> Removed all sync packets (actdiag)
3> I have scanned and had actdiag scan and repair the database
4> Removed all indexes (actdiag) and rebuilt (workstation side)
I remember way back when that there was a file that could be deleted that tracked which records had been sync'd and could be deleted. I can't remember, nor can I find the resource that told me what to do.
06-03-2009 09:46 AM
How many users are actually syncing? Database to database synchronization must only be used between two databases. Not two at a time but two databases only. If three or more databases are syncing using database to database synchronization, you will lose data.
The file you referred to is the TDB file but deleting that may not help.
06-03-2009 10:05 AM - edited 06-03-2009 10:07 AM
The TDB isn't used properly with Database to Database sync...it is reset each sync that way
Which is why it only works for 1 remote (ie 2 databases)
06-03-2009 10:21 AM
06-03-2009 10:32 AM
06-04-2009 04:45 AM
I have two remote users and a central database. What is the "best practice" for them to sync without loosing data and getting all the data sync'd.
How would I remediate the databases so that I could do it the "best practice" way?
06-04-2009 06:17 AM
You will need to combine the databases back into one (you may need to clean the data after that).
Then set up sync via Shared Folder or Email as per either of these ACT! Knowledge Base articles -