• Brandon J Williams (8/13/2014)


    My point is that replication novices are quick to point the finger at replication when it's not replication that is the problem.

    We actually haven't done much in the way of getting a stable replication environment, it just works. Sure, we've read BOL, but as far as getting it stable, that's it.

    You're conflating your experience with the capability or robustness of replication. I've had to be stable in places, I've had it inexplicably fail. Certainly some of the failures have to do with a lack of bandwidth, or maybe disk space, or networking, or data, or something else.

    However that's where replication is brittle. It will fail with things that shouldn't cause it to fail. Just because it hasn't for you, doesn't mean it can't or won't. The fact you reinitialize subscriptions leads to my point that it has plenty of room for improvement (along with other features).