Any suggestions on why the replication job fails when backups are running.
I am replicating data between 11 remote sites and a central site. At one site the replication distribution subsystem gives the message "The process could not connect to Subscriber". The other 10 sites run fine during backups. Any suggestions of where to look to solve the problem would be very much appreciated.
The backups might be causing locks on the database which will prevent replication from processing. Check the logreader and distribution history tables for errors: use distribution select top 10 * From MSlogreader_history --where agent_id= 14 order by time DESC select * From MSdistribution_history --where agent_id= 8 order by time desc