Hello,
every few days my merge replication fails due to a network problem and
subsequent time out. How can I trigger a replication restart automatically,
or at a certain time of day?
Bill,
you can change the workflow properties on your merge agent's job so that the
third step on completion goes to the first step.
Alternatively, you could avoid continuous replication and have the merge
agent run on a schedule.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Sunday, March 25, 2012
automatically restarting merge replication after time out
Labels:
andsubsequent,
automatically,
database,
due,
fails,
merge,
microsoft,
mysql,
network,
oracle,
replication,
restart,
restarting,
server,
sql,
time,
trigger
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment