• Yes, agreed. That is a bit troublesome to sync, though not impossible. Having a synchronous mirror for the distribution server would be helpful. I definitely recommend having a HA solution in place for the distribution server and that includes the proper RAID configuration at the storage layer so that you are not suffering from a catastrophic failure that can't be recovered from locally. DR is another situation and what you spend on that will depend on your requirements. I think that most companies would be willing to suffer the downtime required to reinitialize a publication, even if it has a 30 GB table, to save on some of that from a DR perspective.

    Another note here, in most cases the distribution server is small enough that they will work well on a VM so you could move it there and partake of the VM environment HA solution if you have that in place.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot