• I have yet to find a reasonable solution when it comes to DR for a distributor. Unfortunately there are many exe's outside of SQLServer.exe, ie each repl agent has its own exe. Just open task manager on distrib and you will see.

    The best we do is clustering, however disk is still a single point of failure. And we have our distrib on a separate san than pub, which is same san as our pub's mirror. If we lose distrib we are looking at a full reinit, and we have a very distributed environement, so all pointers go to pub. We log ship remotely, if we have to go to dr site, full reinit, that's just the way it is.

    Microsoft recommends san to san repl, but is very expensive, or maybe there is a 3rd party product out there that can replicate complete images.

    Good luck & regards,

    Chris

    mssqlconsulting.com

    Chris Becker bcsdata.net