Replication alert | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication alert

Hi, 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
Thanks,
Suresh.
Any difference in the edition, mdac version and service packs between the servers? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>