by G'day ...
This question is directed particularly at people who have
had experience with repl. I wish to setup replication
between 2 sql 2000 servers over a 1 meg line. The one site
(LIVE) has 2 servers, a live transaction server which
accepts updates and a report server which is a day behind
only for running reports which is not updated. The second
server (BACKUP) to be part of the replication is located
at a backup site about 80 kms away. Updates will only
occur at the LIVE server during normal operation and the
data will be replicated to the BACKUP server as the
updates occur. I am looking at transactional based repl
since the data needs to be quite up to date. But I am
considering others because purely from a performance point
of view, I will be willing to compromise the up to date
info for better performance. In case of a failure, we
would wish to be able to switch over to the BACKUP server
and continue updating there. The size of the database to
be replicated is approx 30GB.
Is this scenario realistic? In your opinion what would be
the ideal setup?