Community
Showing results for 
Search instead for 
Do you mean 
Reply

Lost Data after Sync

Copper Contributor
Posts: 7
Country: USA

Lost Data after Sync

Here is our scenario.

1. We have main server in Iowa
2. We have a remote server in New York
3. NY server syncs to Iowa server hourly
4. NY team makes 100 changes on Friday

5. Remote USER synced to Iowa server (on Monday). Above 100 changes were lost.


Is this possible? How do we avoid this?

Thank You!

Nickel Elite Contributor
Posts: 619
Country: USA

Re: Lost Data after Sync

Is the loss of changes in the remote database?

 

Are you sure you are seeing the correct remote database?

 

Best regards...   Praxi Solutions Inc

 

 

Juan Carlos Otero Garcia
juancarlosotero@protonmail.com
Silver Contributor
Posts: 1,792
Country: United_Kingdom

Re: Lost Data after Sync

[ Edited ]

Changes are time and date stamp prioritised. Check date setting on remote and server databases.

 

Try check and repair on both server and remote database

Copper Contributor
Posts: 7
Country: USA

Re: Lost Data after Sync

Thank you very much! We will try that out.