-----Original Message-----
From: Troy Settle <troy@picus.com>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: Monday, February 21, 2000 4:15 PM
Subject: RE: [RadiusNT] Redundancy
>
>Not sure what else to say on this.
>
>With transactional replication, the serverports table gets updated within
>seconds of the master DB recieving an accounting record. It's been working
>beautifully for me for about 2 weeks now. We're about to do 2 more
replicas
>for other locations.
>
>Neither the CPU on the main SQL server, or the bandwidth for either site
>took a noticable hit. It's working great.
>
>As for setting up the replication, I just turned to my SQL book (and the
>books online) for assistance. Once I realized that the version on my
>workstation was different than the version on the server, it only took
about
>5 minutes to set the thing up and get it working.
>
>g'luck,
>
>Troy
>
>
>
>
>** -----Original Message-----
>** From: radiusnt-request@iea-software.com
>** [mailto:radiusnt-request@iea-software.com]On Behalf Of Greg Lowthian
>** Sent: Monday, February 21, 2000 4:20 PM
>** To: radiusnt@iea-software.com
>** Subject: RE: [RadiusNT] Redundancy
>**
>**
>** Can you go into transactional replication a little deeper.
>**
>** What I have is one SQL server in NV and the other in CA. The NV server
is
>** the one that billing is being done from.
>** The problem is when the connection in NV goes down (Sprint) the
>** RadiusNT in
>** CA can't get to the SQL for authentication. The SQL server in CA
>** has a copy
>** of the DB but I don't want to do a full transfer every night.
>**
>** > I would not recommend doing a nightly transfer unless you're short on
>** > bandwidth, or don't care about concurrency control. A transactional
>** > replication would be much better for this. I'm doing it now, and it's
>** > actually very light on the CPU and Bandwidth.
>** >
>** >
>**
>**
>** For more information about this list (including removal) go to:
>** http://www.iea-software.com/support/maillists/liststart
>**
>**
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart