sql server replication: Transactional Replication -- sql server replication

Transactional Replication

John
8/31/2005 3:03:23 PM

sql server replication: We're looking at implementing transaction replication over log shipping.
Our question is if it's ever possible for the subscriber server to ever
block the publisher due to the subscriber's momentary inability to keep up
with transaction volume (we're looking at identical hardware, but will be
using the subscriber for some reporting, which could potentially place it
under different load conditions than the publisher).
Thanks!
John

Re: Transactional Replication

Hilary Cotter
8/31/2005 9:38:05 PM

No - due to the store and forward metaphor it is not possible. However you
will now be more vulnerable to exploding transaction logs if your log reader
goes down, and you have a high volume of transactions. This won't bite you
often, but it can.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]