SQL Server Performance Forum – Threads Archive
Replication alertHi, I am performing a replication of pull subscription from X(publisher) to Y server(subscriber) via Z(distributor). Y server is very slow in accessing Z server. So i have copied the snap shot from Z to Y maually and started the distribution agent by updating the sanp shot loc. but it is running for 3 hrs showing the status as "Delivering replication transactions" on distribtion agent and it is not at all showing "snap shot or bulk copyinmg status".It is taking time but fetching the snap shot folder from local system..amazing.. I tried with the same database with different server but it completes the applying sanp shot in 30 mins. Could you please help inb this situation
Any difference in the edition, mdac version and service packs between the servers? Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.