SQL Server 2005 cluster duplicated data
- From: Sean Snider <Sean Snider@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 24 Mar 2008 13:50:02 -0700
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?
.
- Prev by Date: Re: Performance discrepancy between two boxes on an active/active?
- Next by Date: RE: Cluster Installation Failure
- Previous by thread: Performance discrepancy between two boxes on an active/active?
- Next by thread: RE: Cluster Installation Failure
- Index(es):
Relevant Pages
|
