Clustering a Distributor on a SQL server replication

Posted on 2011-10-31
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
    LVL 23

    Accepted Solution

    Distributors can perfectly be clustered.  I wander where you read that.
    LVL 2

    Author Comment

    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
    LVL 2

    Author Comment

    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!
    LVL 2

    Author Closing Comment

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

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    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.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now