I have configured peer to peer transactional replication with two servers (PRI, BCK)
I did the following scenario in testing:
1) I have Load Balance point to PRI server, Now when PRI and BCK servers are up, The synchronization is working fine from PRI to BCK
2) when BCK server is disconnected, then make it online, the synchronization return to work good
3) when PRI server disconnected the load balance switch to BCK server and theres no problem with this
4) after step (3) when PRI server is up, then when i check the synchronization it give the following error:
Error executing a batch of commands. Retrying individual commands
the row was not found at the subscriber when applying the replicated command.
i have traced the error using browsereplcommand and i have found there is a command trying to delete record according to ID but there is no records in both databases have this ID
the table that give the error contain the following trigger in both databases
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
ALTER TRIGGER [dbo].[SysServicesLog_insert] ON [dbo].[SysServicesLog]
NOT FOR REPLICATION
Select @ServiceType = ServiceType
DELETE FROM SysServicesLog WHERE ServiceType=@ServiceType AND SysServicesLogID NOT IN (Select
TOP 500 SysServicesLogID FROM SysServicesLog Where ServiceType=@ServiceType ORDER BY LogTimeStamp
I don't think there is problem with the trigger because its marked (Not For Replication) but maybe !!!
pls need help for this...