Well, you can use a DTS - just schedule the backup server to import data from the primary server and you should be set.
Ian > 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 > -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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