SQL Server transactional replication issues

  • Hi,

    I have set up a Transactional replication. Later I initiated the snapshot agent which finished. Later the subscriber details in the the replication monitor indicates that the snapshot finished in 40 minutes and it took 4 hours to deliver the snapshot.

    I then checked the Distributor to Subscriber details in the the monitor.

    And instead of seeing how many transactions were replicated I see that it has started to deliver the 'same' snapshot to the subscriber. This has happened three time already.

    I dont know what agents forces the snapshot to be delivered and start delivering the transactions.

    Currently both the Log reader agent and the distributor agent are running. The snapshot agent history does not indicate any new occurences. Also the UNC path where the snapshot is saved shows only one snapshot available.

    How do I stop the snapshot being delivered repeatedly. Next how do I start the transactions to get delivered?

    Blog
    http://saveadba.blogspot.com/

  • I think you had a large tables.So please go for the transactional treplication from backup intialization. Where you donot use the snapshot at all......this should help you out

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply