Sql-server – deleted Database data comming back overnight

sql servertable

I am a developer i am facing a situation where Web Application deletes data, on the next morning the deleted data is back on the Database. Yesterday some of our users spent the whole day deleting outdated records on the database only to workup today to findout that the data is back on the tables. So far this is happening on one table. The table doesnt have a unique identifier. I am developer my skills on the database processes are limited, How can i trace the process that does this?

Best Answer

If you are using SQL2014 and up, you can setup an extended event that will track activity on this specific table.

That way, if something re-write the data in the table, you should be able to see where it is comming from: https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events?view=sql-server-ver15