Subscriber database getting refreshed frequently in transactional replication

  • Hi,

    We have configured a pull transactional replication recently and what we have noticed is that the subscriber database is getting refreshed frequently (like every 30min). I am comparing the rowcount of all tables in publisher vs subscriber and initially i see that there are less number of rows needed to catchup. When i check again after an hour i see that this number increases hugely and also most of the tables rowcoutn shows zero.

    All this is happening when there is no activity on out production publication database as it is off-hours now.

    Thanks,

Viewing 0 posts

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