question

nikhil.kadam49521 avatar image
nikhil.kadam49521 asked

SQL SERVER Replication Distributor to Subscriber History Query Timeout.

I am sql server programmer,We have source server and Destination server. Few Replication related jobs are executing when sql server agent is restarted in source server. Those jobs are throwing an errors i guess its related to time out. This job is trying to drop few tables in destination server at the same time few Our jobs in destination server using that tables.So our DBA team is providing those blocked transactions to identify the issue. My question is why they are not stopped our jobs in destination server before they are start their replication jobs in source server.

replicationsql serversql agent
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.