January 30, 2012 at 9:06 am
Hi all,
I have defined a transactional replication between two sql server 2000 databases. The publication only have one article. When snapshot is applied, for sincronizing, first all rows are deleted.
The main replication agents schedules are:
- Snapshot Agent --> Is disabled. I generate the snapshot manually when is neeeded.
- Log Reader --> It is running continuosly.
- Distribution Agent --> It is running every hour between 0:00:00 hours and 23:59:59.
The snapshot and Log Reader are running correctly, but when Distribution agent begin to run (as i say every hour),
it automatically delete all register in the target database table, and start a new bulk insert process (similar to the first sincronization process). I dont undertstand this comportament, because distribution agent only should have replicate the changes (and only the changes) succeded between hours.
I have see in sql server and agent log but i can't see any error message. I have to say that the time needed for the first sincronization process is 2:30 hours.
Somebody help me?
Many thanks in advance.
February 3, 2012 at 5:12 am
Hi all,
I find the problem. The replication was running correctly. The problem was that the source table was been deleted completly and reload completly for a external application. So, the replication actions were one DELETE and the ALL INSERT statement.
Many thanks to all.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply