SQLTeam.com | Weblogs | Forums

Lost Record

I copy the records on my database to compare if the data i have will not be lost. After two days, when i check the original database, i found that some of the records are missing. i look at the log if someone deleted it but found nothing. is there something wrong?

  1. What log are you talking about?
  2. Do you have backups?
  3. Do you have some sort of audit table that tells you who deleted what on which datetime?

Thanks for your response.
The logs I been asking are the one who uses ms SQL.

I have backup of my database to check changes made.

I have an audit table that tells me what the user did. However, there are no delete operation recorded. so I dont have idea, what the hell is going on. Some records were deleted but I cannot trace how it was done.