Or use logshipping. We are looking at doing this with our new SQL 2005 boxes Production logships it txn logs then secondary has a job to go get logs every 5 mins.
So secondary is always 5 mins behind but is in READ Only mode for reporting queries Eric On 1/22/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > James Smith wrote: > > > > The problem I am having is that replication is insisting on referring to > the > > servers by name not by IP address and since the web server is remote and > not > > on our LAN it's name is not available. > > Add it to your hosts and/or lmhosts file. > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
