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:1741 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:>
