Jump to content
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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Who Viewed the Topic

    2 members have viewed this topic:
    reynir  DavidTO 
×

Important Information

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