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. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.coolfusion.com/products/prismav/prismavforcoldfusion.cfm Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1743 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:>
