By default, Subscribers to transactional publications should be treated as read-only, because changes are not propagated back to the Publisher. However, transactional replication does offer options that allow updates at the Subscriber.
In this video, i have shown a demo on how to handle error, if subscriber deletes a record without knowing to publisher.
Part 1: • Replication in SQL server - Part 1 ||...
Part 2 : • Replication in SQL server - Part 2 ||...
Part 3 : • Replication in SQL server - Part 3 ||...
Watch video Troubleshoot Error in Transactional Replication || Record deleted at Subscriber || SQL DBA online without registration, duration hours minute second in high quality. This video was added by user Right to Learn @BK 01 November 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 10,261 once and liked it 220 people.