4

I have configured transactional replication from SQL Server 2008 to SQL Server 2014. And everything is OK, except one thing: after the initial snapshot is delivered to subscriber, distribution agent starts to deliver it again, the same articles in the same order, instead of applying undistribution transactions, pending delivery.

replication

I tried to reinitialize subscription, re-create subscription and generate new snapshot, but it doesn't help. There are no any errors in any of agents history, but snapshot delivery is just looped.

How can it be fixed?

Improve this question
1
  • 1
    So, by some reasons it was happened because triggers and non-clustered indexes were included in replication. After they were excluded the snapshot delivery didn't loop anymore. And after snapshot was delivered, I just created all missing indexes and triggers manually on the subscriber as a workaround.
    – Sergey M
    Commented Mar 21, 2017 at 7:37

1 Answer 1

Reset to default
1

So, by some reasons it was happened because triggers and non-clustered indexes were included in replication. After they were excluded the snapshot delivery didn't loop anymore. And after snapshot was delivered, I just created all missing indexes and triggers manually on the subscriber as a workaround.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.