From: "Brian Dooley" <email@example.com> Subject: RE: [RadiusNT] RadiusNT and SQL Server Replication Date: Wed, 29 Nov 2000 21:59:00 -0500 Message-ID: <NEBBJONIMLFKPKHPCJMKMEGICNAA.firstname.lastname@example.org>
I am not using multiple SQL servers, but did experience a problem with DUPE
index key violations.
Based on a previous post elsewhere herein, I altered the Primary key to
include something that would make it unique and not likely to be able to
duplicate as easily.
Verbatim > -----Original Message-----
Verbatim > From: email@example.com
Verbatim > [mailto:firstname.lastname@example.org]On Behalf Of
Verbatim > Chris Stone
Verbatim > Sent: Wednesday, November 29, 2000 7:15 PM
Verbatim > To: 'email@example.com'
Verbatim > Subject: [RadiusNT] RadiusNT and SQL Server Replication
Verbatim > Anyone have this setup and running - RadiusNT 3 and SQL
Verbatim > Server 7.0. Have 2
Verbatim > radius and 2 SQL servers - a pair of each at 2 separate
Verbatim > locations. Each
Verbatim > Radius server uses it's local SQL server for the primary database
Verbatim > connection. In setting up SQL merge replication, the
Verbatim > initial snapshot goes
Verbatim > fine and the replication will work quite nicely for a
Verbatim > few days and then we
Verbatim > start getting replication failures - primarily due to
Verbatim > violations of index
Verbatim > keys.
Verbatim > Anyone have this type of configuration running
Verbatim > successfully that might be
Verbatim > able to provide a bit of insight into how to resolve
Verbatim > these issues?
Verbatim > Chris Stone, MCSE
Verbatim > WebConnects, Inc.
Verbatim > email: firstname.lastname@example.org
Verbatim > web: http://www.wcox.com
Verbatim > ------------
Verbatim > This is a user supported list. If you require assistance
Verbatim > from IEA Software's
Verbatim > Support Engineers, please check out our Support resources at
Verbatim > http://www.iea-software.com/support.
Verbatim > For more information about this list (including removal) go to:
Verbatim > http://www.iea-software.com/support/maillists/liststart