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