SQL Server 2005 cluster duplicated data

#11

Whatever may be causing your data duplication problem, one thing I'm sure: it
has nothing to do with the fact that the SQL Server instance is clustered.
Personally, I'd start by looking at the app.

Linchi

"Sean Snider" wrote:

Quote:

We have a 64 bit SQL Server 2005 Cluster (Active/Passive) that was upgraded
from a 32 bit SQL 2000 Server. Our cluster is not yet running Service Pack 2.

We hosted an ASP.Net web application as the front end for a few internal
contests. Over the course of these contests rarely and at intermittent
intervals data duplications occurred. Here is an example showing what some
of the data anomalies looked like:

User Date Posted Question Answer
user1 3/15/08 3:33 PM Communication involves the 4 following
user1 3/15/08 3:33 PM Cuál 2 ramas de la biblioteca ofrecen
user1 3/15/08 3:33 PM What is the most important element
user1 3/15/08 3:33 PM When it comes to heart disease, FALSE
user1 3/15/08 3:34 PM Communication involves the 4 following
user1 3/15/08 3:34 PM Cuál 2 ramas de la biblioteca ofrecen
user1 3/15/08 3:34 PM What is the most important element
user1 3/15/08 3:34 PM When it comes to heart disease, FALSE

Notice that the duplicate entries all happened 1 minute after the original
insert.

Could this behavior be caused by a miss configuration or problem with the
SQL Server cluster?

If so is upgrading to Service Pack 2 likely to resolve the issue or is there
some other solution that is recommendable?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Server 2005 cluster duplicated data

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

RE: SQL Server 2005 cluster duplicated data - 03-24-2008 , 09:17 PM