I have a Transactional Replication setup which has been working fine for a long time. It is a Pull Subscription. I got a new requirement to replicate a large article which is 10GB.
allow_anonymous & immediate_sync are set to false by default.
I added the new table from GUI and then started the snapshot agent. The initial snapshot got created successfully.
However, it is not replicating from distributor to subscriber with below error message.
2023-09-05 11:30:53.835 Bulk copying data into table 'xxxx'
2023-09-05 11:35:54.055 The process is running and is waiting for a response from the server.
2023-09-05 11:40:54.266 The process is running and is waiting for a response from the server.
It is showing the same error for the last 3 hours. The undistributed commands are increasing every minute. There are no blockings on Publisher or Subscriber.
However, I see that the Bulk Insert SPID related to Distribution agent is waiting with wait type Async_Network_IO error.
Please note that it has stopped replicating all other tables as well.
Kindly let me know how to fix this issue.
