Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Replication Automatic Failover
0 views
Skip to first unread message
M Ellis
May 14, 2004, 2:01:04 PM5/14/04
to
COuple of replication questions
1. Does the product automatically recover conenctions after an outage
2. Does is automatically complete all rep. tasks that were not completed after it went down?
3. Any restriction on the number of systems (I think the distributor "node" can replicate to multiple subscribers - correct?
4. Does it support referential integrity?
1. Does the product automatically recover conenctions after an outage
2. Does is automatically complete all rep. tasks that were not completed after it went down?
3. Any restriction on the number of systems (I think the distributor "node" can replicate to multiple subscribers - correct?
4. Does it support referential integrity?
Thanks
M Ellis
Paul Ibison
May 14, 2004, 4:17:40 PM5/14/04
to
The merge or distribution agent can fail with a connectivity error on an
outage. Simply restarting it fixes the issue and it continues where it left
off, although it appears that this is not entirely foolproof - there have
been posts to this effect previously. To ensure restarting, you can set the
job steps to run in an infinite loop.
outage. Simply restarting it fixes the issue and it continues where it left
off, although it appears that this is not entirely foolproof - there have
been posts to this effect previously. To ensure restarting, you can set the
job steps to run in an infinite loop.
I am not aware of any limitation in the number of subscribers.
Referential integrity can be sent down as part of the article properties
assuming the related articles are replicated inthe same publication. If not,
you can use sp_addscriptexec to add the FKs.
HTH,
Paul Ibison
0 new messages