We use a piece of software called DoubleTake. It does real-time mirroring
between different computers. In fact it will allow you to mirror multiple
servers into 1 server. We use it to mirror 3 of our servers, one of which
is our SQL Server, into 1 warm standby server. Our SQL server has about a
dozen databases in it with a total of just over 3Gb of data.
You can configure the software to either automatically switch on failure, or
prompt for switching, we use the prompt option so we can control when it
switches. We have actually used the failover feature a couple of times and
it worked very well.
Bill Grover
Supervisor, IS
EU Services, Inc.
649 N Horners Ln
Rockville MD 20850
Phone: 301-424-3300 x396
FAX: 301-424-3300 x1396#
E-Mail: [EMAIL PROTECTED]
-----Original Message-----
Date: Wed, 27 Jun 2001 12:32:04 +0200
From: "Michael Lugassy" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: replication software for sql
Message-ID: <014501c0fef4$69196080$[EMAIL PROTECTED]>
I'm trying to replicate 2 remote databases that holds about 2-3gb of
information.
most of the changed information daily is about 400-500 mb and weekly, 1gb.
Is there a good replication software for sql that support resuming and might
help me handel this scenarion better then the built-in mechanisem in sql 7?
Thanks,
Michael Lugassy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
