Check BOL for transactional replication My dba's have it set up. As I understand it, every transaction is replicated from a publisher to subscribers. Basically what you are looking for, I think. They set it up so I'm not very knowledgeable about it.
Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] >>-----Original Message----- >>From: Ben Densmore [mailto:[EMAIL PROTECTED]] >>Sent: Monday, October 07, 2002 2:47 PM >>To: CF-Talk >>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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
