question

thennarasu avatar image
thennarasu asked

Find who deleted the rows in table in sql server

i have a database configured simple recovery model with daily full backup at 12:00 PM IST it has table name called 'Blod' with 50 records and another table called 'comment' it has the foreign key reference to 'Blod' table with deleted cascade ,some one has deleted the record form 'blod' table two days before, all the detail form both the tables are deleted ,now i need to find out who deleted the record i used fn_dblog to find out but it does not have the record since it has a full backup all the logs are truncated ,what is the way to find who deleted the record? anyone kindly suggest
sql-server-2008sql-server-2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
You will not be able to find out who deleted the records unless you have custom logic like triggers etc which logs changes. If this is something you want to track for the future, you should configure Auditing in SQL Server.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.