(no title) (original) (raw)

Ok, I'm like in Sherlock Homes mode this Thursday. Records have been deleted from a table in a production databse. It's a deadicated server. I wrote the entire application (asp.net/C#/sql server). The application only hits database via stored procs and the table in question - records are never deleted by the application, they do get set to a deleted statusID if need be.

Apparently someone else in the company has been using the server as I noticed a database for another application, it seems as though someone just deleted those records as I've search all procs and functions scripted out and that table is never deleted. The table is in a cascading delete from the parent table but the parent records are still there.

Any advice on figuring what the hell happened? I'm restored a database to last night and the records are still gone, going back a few days before to get an idea of the time frame. I am running a long but don't have experience really using it and right now I'm running trace to see who/what is accessing the database.

Any info is appreciated. TIA>