Our Test DB is suddenly missing rows. We want them back.
Is there a way to sift through everything that has happened to the database today? Each SQL statement? I presume this kind of stuff is in the transaction log, but am not sure how to view it.
Is there a way to undo delete operations?
BTW: Yes, we do have a backup, but would prefer to find the cause of the deletion as well...
You can do this with some of Red Gate's tools, but it costs. Take a look at SQL Log Rescue.
Otherwise, I'd be tempted to do a restore.