On Mon, Feb 16, 2009 at 1:16 AM, C. Hatton Humphrey wrote:
> The main thing I'm worried about is any performance "hit" on the
> publishing server.  The target server can lag behind data-wise by a
> bit (30 minutes to an hour is an acceptable delay).

Those do not appear to be very challenging requirements. You could
probably even do this without any of the built-in replication at all
but with just incremental backups. How have you currently configured
your backups? Do you notice a performance impact when you run a full
backup? Do you notice a performance impact when you run a transaction
log backup?


> The problem is the size.

For performance size doesn't matter all that much. What matters is
update volume.  What is the transaction log volume per hour? How long
does it take to apply (replay) that transaction log volume currently?

Johem


-- 
Jochem van Dieten
http://jochem.vandieten.net/

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319367
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to