Clustering a Distributor on a SQL server replication

Posted on 2011-10-31
Medium Priority
Last Modified: 2013-06-19
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.

Thank you

Question by:hlaprade
  • 3
LVL 23

Accepted Solution

Racim BOUDJAKDJI earned 1500 total points
ID: 37059784
Distributors can perfectly be clustered.  I wander where you read that.

Author Comment

ID: 37060176
Racimo Hi, as far as we are reading, it looks like it does involved a very tedious manual process and we are looking for something not necessarily unattended but secure, for us being down at certain times is a death sentence, we lost business past two weeks and one of the reasons was the distributor with a faulty memory, as we read looks like it involves a lot of manual changes since the sql will failover but not the replication aparently and that scares customers and investors since we are being having a bad situation.
Is there a literature you want to share on this matters or do you know a company that can oversee this process?
Best reagards

Author Comment

ID: 39261133
I've requested that this question be closed as follows:

Accepted answer: 0 points for hlaprade's comment #a37060176

for the following reason:

It is a really hard thing to do, but still it is a possible solution, as the technology change it will become easier!

Author Closing Comment

ID: 39261134
Since he did not provide any documentation or any other idea, but still he gave a good answer.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question