SQLTeam.com | Weblogs | Forums

High Availability Option for Replication Subscriber and Distributor Database

sql2008

#1

Hi,
Currently we are SQL 2008 R2 Enterprise version. We using database mirroring for publisher database which give us a highly available database and server disaster recovery option also. BUT we still have single point of failure for replication(merger/transactional) subscriber and distributor database. We are planning to make subscriber and distributor database highly available also. Is there any option to make subscriber and distribution database high availability? i don't mind to upgrade my SQL version to higher if there is solution for this in higher version. Please helps to give idea on this.


#2

Hi,
Is that no one in this forum familiar with high availability setup? Please help to advise.


#3

Within 24 hours on a Saturday and for free? Nah, I expect all the others are out at the beach ...

You need to hire a consultant if your timeline is critical and/or your problem is complex.


#4

Hi Kristen,
Thanks for the reply.
Sorry if my language too harsh earlier.
Actually my timeline not critical and my problem is not complex though.
I just asking here for some guidance/workaround and idea for my future project for SQL HA and DR suppose.
I will wait for someone to reply though based on their experience.
Hope i can get some ideas on the subject that mentioned.
How about you Kristen? Do you have experience working with SQL HA and DR? Hope you can share your experience Kristen.


#5

AOAG / HARD wasn't introduced into SQL Server until 2012, so an upgrade will be a must. Beyond that, this is a fairelycomplex topic, well beyond the scope of a forum post. Fortunately, there is no lack of articles available on the web.


#6

Hi Jason,
What is HARD? So AOAG able to support replication subscriber and distributor database?


#7

Sorry... It's a mistype. Should have been HADR (High Availability Disaster Recovery).