SQL DBA Tutorial 180-How to setup Replication with AlwaysOn Availability Group in SQL Server P2

In this video you will learn following:
1- How to setup replication with AlwaysOn Availability Group in SQL Server
2- How to configure Remote Distributor in SQL Server
3- How to enable Replication on all Replica in AlwaysOn Availability Group
4- How to add possible publisher at remote Distributor in AlwaysOn Availability Group
5- How to Validate replication
6- Resolution of below Error:
Msg 21892, Level 16, State 1, Procedure sp_hadr_validate_replica_hosts_as_publishers, Line 60

Visit our website to check out SQL Server DBA Tutorial Step by Step

[ChiragPatel-wihb]

It's really amazing help I have ever seen in my IT career.
Thank you very much both if you Aamir and Raza.
Please post some videos on Windows SQL Azure performance tuning and troubleshooting.
Greatly appreciate for all your help.

[kamarchand]

I tested this and when the SQLPROD computer is shutdown there is no replication active anymore.
Is there a way to have NYSQLPROD replicate when SQLPROD computer is down?

regards

[arshadmahmood]

It is really nice video ...thank you so much...I am just curious about: After Failover to NYSQLPROD, Should the publication stay under SQLPROD or it should move to NYSQLPROD? If SQLPROD goes down, will it effect the replication ?

[Rewslaun]

Great video TechBrothers, it has been very informative. I am having a problem that I'm hoping you can help with. I used your scripts to add replication to my availability group and it worked on both nodes. The business unit then required me to remove the replication as they replaced the DB. After running my scripts (just to add the publisher and subscriber, the distribution db was left setup) I am now having an issue when I failover from AG1 to AG2. The replication immediately errors and it shows that it's trying to connect to the previous primary AG1 even though AG2 is now the primary. I have run the redirect publisher script but it still doesn't matter. I have triple verified my setup. Any suggestions you can give would be appreciated.

[umeshsinghm]

If subscriber also part of always on how to configure replication ?

[SumitKumar-lbxn]

I treid to ask question on your blog but its not responding in correct way ..
Just one more question how does the request gets routed to secondry ..because listener do not perform yhe load balancing

[SumitKumar-lbxn]

Hi guys i have question ...if we set up secondry replica as read only than in the application string do we need to put the listener name or secondrys node name..