Database replication ain’t as easy as it looks

In a recent meeting I came up with a brilliant (well it appeared as such at the time) solution to user database replication to easily create a copy of a database based system (SharePoint) at a remote location.  Well it’s actually on a ship that has a 2 way satellite link.  Available bandwidth is an issue, also we need to ensure the documents are available in the event of the loss of data communications.  Sounds simple right?  Just replicate the database, connect the system up and it’s all good.

Well, that’s what I thought too.  What could possibly go wrong?

Read more