I am struggling to configure transnational replication between some retail stores and head quarter. Some of the retail stores doesn't have very good connectivity and the link might be down for few hours. This breaks down my replication. I am re initializing my replications without snapshot as it is very slow if I take a snapshot and apply that again.
What I am looking for is a solution for this scenario, so that even if the network is down for few hours, the replication again picks up. I don't want the agents to stop after several retries.
Is there any setting that I should do so that replication doesn't stop after several retries.
Online Trainer For SQL DBA and Developer @RedBushTechnologies
with 16 yrs exp.