SQL Server: How To Configure Always On With Replication

Always on with Replication:

Node1 : Primary Replica
Node2 : Secondary Replica
Node3 : Distributor
NOde4 : subscriber

use master
exec sp_adddistributor
@distributor = N'Node3'
===================================

USE distribution;
GO
EXEC sp_redirect_publisher
@original_publisher = 'Node1',
@publisher_db = 'Adventureworks2019',
@redirected_publisher = 'RListen';

Join the whats app Group for the scripts and assistance:

You Can Also Download the scripts from below floder
We strongly believe there is always chance of betterment, so suggestions are most welcome.

Happy learning, and best of luck in your professional journey!

The journey of improvement is ongoing and never be an end.

Thank you!
MS SQL DBA Tech Support

[azharuddinmohammed]

Excellent harsha the concept is really good👏

[ssv]

Awesome very much thanks for sharing such a nice content 🎉

[vasurayapureddy]

It was good session. Thank for the video.

[cinematiccutups]

This is a great video but I couldn't quite understand what exactly is the benefit of doing this or in other words what kind of situation could we possibly face in the real world in which this solution is suitable.

[Motivation-wpus]

Hello Sir,
can we setup two node like, node1 as primary (read/write) node2 as secondary standby (for high availability). and node3 for read replica (for application) with this approach in SQL server Standard Edition ?

[solankiitsolutions]

thanks nice video, can we put the same name of the database on publisher and subscriber server?

[eramitmcsa]

you have perform it in Domain Environment or Workgroup Environment