Hi All
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.
thanks
SK
Consider removing transactional replication and switching to log shipping to get your data to a central server. From there you can massage/copy it to a mother-ship database as needed. I have used this countless times for clients over the last 25 years of consulting on SQL Server.
Replication is just a mess IMNSHO.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service