You might be interested in looking into "Log Shipping" or "Failover Clustering".
-Novak ----- Original Message ----- From: "Ben Densmore" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 07, 2002 12:46 PM Subject: SOT:SQL Server Backup > Does anyone know off hand if there is a tool or if SQL Server has this > built in where you can replicate what's on one DB Server to a second DB > Server? We need to build a failover server as a backup to our SQL Server > System but want all the data on the backup server to be in synch with > the main server. I know Win2k has the briefcase thing where you can sync > up folders, but that seems to be a bit for just a typical end user, I'm > guessing where SQL Server is enterprise level that it may have something > built in? > > Thanks, > Ben > > Ben Densmore > Web Developer > eSupport.com,Inc. > 1538 Turnpike St. > North Andover, MA 01845 > > Phone: (978) 686-6468 x333 > Email: [EMAIL PROTECTED] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
