SQL Server: How To Configure Always On With Replication

Published: 04 June 2023
on channel: MS SQL DBA Tech Support

7,843

Always on with Replication:

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

use master
exec sp_adddistributor
@distributor = N'Node3'
,@heartbeat_interval=10
,@password='123#
===================================

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:
https://chat.whatsapp.com/KPXLozGtE9C...

You Can Also Download the scripts from below floder
https://drive.google.com/drive/folder...
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

Watch video SQL Server: How To Configure Always On With Replication online, duration hours minute second in high quality that is uploaded to the channel MS SQL DBA Tech Support 04 June 2023. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 7,843 times and liked it 84 visitors.

10,484