question

fkettani avatar image
fkettani asked

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
clusterfailover
10 |1200 characters needed characters left characters exceeded

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

sqlaj 1 avatar image
sqlaj 1 answered
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 comment
10 |1200 characters needed characters left characters exceeded

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

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 Likes 0 ·
H_G_H avatar image
H_G_H answered
Are you using AG functionality in 2012 ? please review this artical, http://technet.microsoft.com/en-us/library/hh710046.aspx. Thanks
10 |1200 characters needed characters left characters exceeded

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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