Saturday, February 25, 2012

Queued Updating

When i configured replication by default SQl Server (2000) use the Queued
Updating
what does it mean "changes queued at the subscribers until they can be
applied at the publusher" ?
Thanks
Message posted via http://www.droptable.com
somebody can help me on the topic?
Message posted via http://www.droptable.com
|||If you insert/update/delete a record at the subscriber it won't enter a 2PC
transaction like immediate updating subscribers, but will enter a queue
table (or MSMQ) on the subscriber. Only when the queue reader agent is run
will the commands be propagated to the publisher. So, things like identities
need more thinking about, as they'll be managed on the publisher and
subscriber, due to the increased autonomy of the subscribers.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||thanks
Message posted via http://www.droptable.com

No comments:

Post a Comment