Jump to content
Sign in to follow this  
GisMo

FMEasySync: Server Database Corrupted - What's the best way to rebuild from clients?

Recommended Posts

Somehow my current and last 7 backups are corrupted and unable to be recovered via FM. Ugh.

 

What's the best way to rebuild the server database from the clients' data such that it's minimal impact to clients? Anyone have step-by-step instructions to reseed the database client data and make sure everything gets synced properly?

 

Edited by GisMo

Share this post


Link to post
Share on other sites

Not sure what you mean by 'reseed the database' & 'sync'

Is this a solution that syncs data between two locations?  If so, which of the two location has the corrupt solution?

More often than not a FM file will get corrupted because something is wrong in the deployment itself, so spend enough time on that to verify that everything is up to best practices otherwise your newly rebuilt files may just suffer the same fate again.

Share this post


Link to post
Share on other sites
3 hours ago, Wim Decorte said:

Not sure what you mean by 'reseed the database' & 'sync'

Is this a solution that syncs data between two locations?  If so, which of the two location has the corrupt solution?

More often than not a FM file will get corrupted because something is wrong in the deployment itself, so spend enough time on that to verify that everything is up to best practices otherwise your newly rebuilt files may just suffer the same fate again.

Hey Wim,

This is FMEasySync; records are synchronized between a client and hosted database. This is a solution that has been working for over a year with multiple clients. The server database is corrupted and I think my root cause is related to something outside of the solution itself. A HD on the server had health after doing some testing, so I moved all data to a newer drive.

I still need a solution for rebuilding the server database from the clients' data.

 

 

 

Edited by GisMo

Share this post


Link to post
Share on other sites

Can you physically get a copy of the client database to export the data out and import into yours?  Worst case you'd have to do a full client -> server sync.

Share this post


Link to post
Share on other sites

I have 4 clients who haven't synced. I would need all 4 local databases and then merge them into one. I guess before I experiment, has anyone got any suggestions?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.