SQLTeam.com | Weblogs | Forums

Database record missing

#1

Hi,
My database record suddenly missing, there's no action of deleting the record. But it is missing..or deleted..
My database already run for 4 years..
Does any one have any solution and why it can be happened?

thx

#2

There are many possibilities without more detail it's hard to say why. Was the row wrapped in a transaction and the transaction failed so the row was never actually added in the first place? Was a backup of the db restored from before the row was added? Are just 2 possible answers.

#3
  1. I believe the data already stored because many transaction based those data were taken. And it is used many weeks ago
    2.I try to restore the database and it is exists.Just wonder why that can be happened
    now I create new database and restore the old into the new one. And monitoring hope that is db problems