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?
- What log are you talking about?
- Do you have backups?
- 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.