Oops...replied to the wrong email. Working too many hours. :) ----- Original Message ----- From: "Dina Hess" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, November 13, 2003 9:08 PM Subject: Re: Replication
> Thanks, Tony! Cute. > > > ----- Original Message ----- > From: "Dharmendar Kumar" <[EMAIL PROTECTED]> > To: "SQL" <[EMAIL PROTECTED]> > Sent: Tuesday, November 11, 2003 8:33 PM > Subject: RE: Replication > > > > Another alternative to DTS and replication would be SQL Server log > > shipping - though I am not sure if it would suit your needs. > > > > log shipping is the process of automating the backup of database and > > transaction log files on a production SQL server, and then restoring them > > onto a standby server. The key feature of log shipping is that is will > > automatically backup transaction logs throughout the day (for whatever > > interval you specify) and automatically restore them on the standby > server. > > This in effect keeps the two SQL Servers in "synch". Should the production > > server fail, all you have to do is point the users to the new server, and > > you are all set. Well, its not really that easy, but it comes close if you > > put enough effort into your log shipping setup. > > > > This is mainly useful as an inexpensive means of SQL Server failover. > > > > DK > > > > -----Original Message----- > > From: Kay Smoljak [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, November 11, 2003 9:28 PM > > To: SQL > > Subject: RE: Replication > > > > > > Well, after reading a couple of sites, BOL, and talking to you guys, I'd > say > > that's what I'm going to do. But now I know soooooo much more about > > replication :) > > > > Thanks Mike and Snapple... > > K. > > > > > -----Original Message----- > > > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, 12 November 2003 10:23 AM > > > To: SQL > > > Subject: RE: Replication > > > > > > Just schedule the DTS package to run at certain times.. :-) > > > You should be fine with that approach. You can always execute > > > the package prior to meeting with a client, thus giving you > > > the current information only when needed. > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://affiliates.macromedia.com/b.asp?id=2439&p=go/dw_aff1 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1745 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
