Hi,
I am monitoring my replication process and I have a problem with the loop detection, I can see origined transacctions in the server, executed in the same for the replication.
The subscriptions configuration is sp_helpsubscription
exec sp_addsubscription @.publication = N'PUBLICATION',
@.article = N'all',
@.subscriber = N'192.168.0.23',
@.destination_db = N'PRUEBABD',
@.sync_type = N'none',
@.update_mode = N'read only',
@.offloadagent = 0,
@.dts_package_location = N'distributor',
@.loopback_detection = 'true'
GO
I need for help.
Sorry, it's not clear to me what the problem is. Are you getting an error of some sort?|||Yes, I have loops in the replication between the subscribers and too many deadlocks.
My topology is
Server A replicates to Server P,
the Server P replicates to Server A,
Server B replicates to Server P and
the Server P replicates to Server B.
I am using transactional replication,
|||sorry, i'm still not clear. what exactly is the error. if it's deadlock, what statements are deadlocking?|||My problem is that loop back detection is unless when I registed the subscriptions with IP. The publicator servers are registered for name.
No comments:
Post a Comment