disappearing data in database

We have experienced a problem recently. Where data that
was inserted/updated in the database, and verified that
they were in there, disappeared hours later. We have no
idea what is happening. The data was entered through a
Centura application or lotus notes pump job. There are
hard copies verifing that the data was there. When they
go back to alter the data, it is missing. I checked the
sql server logs and the only thing in there is the dbcc
messages and the backup messages. Nothing saying the
database was restored or any errors. I also checked the
Windows NT logs and there was nothing in there either.
Does any one know what could be happening? We are running
sql 7.0 sp4.
Thanks
DianeA suggestion might be to run a SQL Profiler Trace while
the database is in use. This will tell you exactly
what/who is doing what and when to the database.
Its something to try at least
>--Original Message--
>We have experienced a problem recently. Where data that
>was inserted/updated in the database, and verified that
>they were in there, disappeared hours later. We have no
>idea what is happening. The data was entered through a
>Centura application or lotus notes pump job. There are
>hard copies verifing that the data was there. When they
>go back to alter the data, it is missing. I checked the
>sql server logs and the only thing in there is the dbcc
>messages and the backup messages. Nothing saying the
>database was restored or any errors. I also checked the
>Windows NT logs and there was nothing in there either.
>Does any one know what could be happening? We are running
>sql 7.0 sp4.
>Thanks
>Diane
>.
>