records disappeared from sql server 2000 database

I have a VB6 application using SQL Server 2000(SP4) database. One user
entered about 50 timesheets on one computer yesterday. This morning they are
gone. I restored it from the backup database as of midnight 12:00 and those
records are not there. We checked everything we can think of. And in the log
file the database is closed around 5:00 yesterday.

Any suggestions?

Thanks

Sounds like an aborted transaction. Do you do transactions?

"Mary" wrote in message

>I have a VB6 application using SQL Server 2000(SP4) database. One user
> entered about 50 timesheets on one computer yesterday. This morning they
> are
> gone. I restored it from the backup database as of midnight 12:00 and
> those
> records are not there. We checked everything we can think of. And in the
> log
> file the database is closed around 5:00 yesterday.
>
> Any suggestions?
>
> Thanks
>
>