Failover clustering of the distributor and subscriber server

Question

question

fkettani asked Oct 24, '13

Failover clustering of the distributor and subscriber server

We have SQL server 2012 standard edition. We are using transactional replication. The distribution agent and distribution database are on the same server as the subscriber. Ì want to cluster the subscription server (with the distributor) and use database mirroring to have redundancy of the subscriber's databases. My question : In case of a failover of the subscriber-distributor server, can the publisher be automatically be re-directed to the failover server ? Thanks for your help

cluster failover

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-10-24T19:12:34Z

sqlaj 1 answered Oct 24, '13

I have clustering setup and I have transaction replication but not the two combined. This post shows how to set it up for SQL 2008. There is even a video. http://thedbavault.blogspot.com/2012/08/ms-sql-server-2008-transactional.html

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

fkettani commented · Oct 24, 2013 at 07:45 PM

Thank you very much for your excellent article. It was very clear. I still have a question though: Can I have the distributor and a subscriber in a failover cluster, while the publishers are outside the cluster? Thanks again. Farid

0 ·

Answer 2 · 2013-10-27T19:53:25Z

H_G_H answered Oct 27, '13

Are you using AG functionality in 2012 ? please review this artical, http://technet.microsoft.com/en-us/library/hh710046.aspx. Thanks

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question