If the publisher database is set on simple recovery mode and if the
transaction log gets truncated on check point, then is there a chance that
the rows that should be replicated might get lost before the log reader agent
can read them and send them to the distributor. Publisher is a 7.0 box and
the distributor/subscriber is a 2000 box.
Adam,
the rows won't be removed unless the log is marked by sp_repldone, so you're
safe.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment