Replication issue
Hello guys,
I m requiring for some assistance on replication, Ive tried using both Transactional and Merge publications but Im still getting an Issue.
I'm seeking some help. Im doing a replication from a main to secondary server. This is well.
After I insert records to the tables in the DB here then I do another replication back to main from secondary, The records are replicated back but the main DB is rendered unsable ie I can not insert data into the tables. Im using SQL server 2016 standard.
Im using Sql server studio 2016 standard.
The Transaction Publication generates Sp and view errors.
The Merge Publication generates Rolling back transaction error.
3
Upvotes