Clustering a Distributor on a SQL server replication
Posted on 2011-10-31
Hi Guys, I am currently have a sql server issue, I am using sql server 2008 with replication, one publisher one distributor/subscriber and 2 additional subscribers and I had an outage yesterday night where the distributor failed and stop replicating to the subscribers. These distributor/subscribers is a R710 4proc/24 cores 128 gigs of ram and two of the dims failed.
I want to identify a way to remove this single point of failure using either cluster or virtualization. So far I read that the distributor cannot be a cluster and some other people claim that if you take the temp folder for the distribution to an external storage and define it as a share resource that will take care of the problem when the SQL fails over so the replication will continue working.