"Dipankar Ganguly" <dipankarganguly@hotmail.com> wrote in message
news:be8835c2.0312170647.a4e7224@posting.google.com...
> Hi,
> Please help me to solve the following scenario. We are
> working on SQL Server 7.0 on Windows NT Server with Raid
> 5 . We are using a front end application through which all
> the things are done. For the last few days we are finding
> that certain sets of transactions are disappearing from
> the database totally e.g.
> 1. Certain books are sold to the customers.
> 2. Stock is reduced.
> 3. Delivery instructions are generated from the system.
>
> Say Point 1 & 2 are within same transaction whereas Point
> 3 is a separate transaction based on the committed transactions of
> Point 1 & 2. Now the next day or on
> the same day after 3-4 hours we find that all the
> transactions are reverted. It is creating a big problem.
> Is it problem with SQL Server / Windows NT / Virus / Hardware ?
> Please give suggestion.
>
> Thanks in advance.