If someone has deleted the table in a database, then how can you find out the user that has deleted the table ? Can you find out using the log file? Can you retsore the table using the tail log backup?

Question

Accepted Answer

Yes, the user who deleted the table can be identified using the transaction log file.

To find out the user who deleted the table, you can query the transaction log file using the fn_dblog function.
The transaction log contains information about all the transactions performed on the database, including the table deletion.
By analyzing the log records, you can identify the specific transaction that deleted the table and retrieve the associated user information.
Restoring the table using the tail log backup is possible if the backup was taken after the table deletion and before any subsequent log backups.

Accepted Answer

There is an undocumented function called fn_dblog which enables you to read data from your transaction log which contains very informative data about things that are happening in your database

Accepted Answer

I can check user log files and find the user witch has deleted the table. I can restore using log backup.

If someone has deleted the table in a database, then how can you find out the user that has deleted the table ? Can you find out using the log file? Can you retsore the table using the tail log backup?

Top DXC Technology MS SQL DBA interview questions & answers

Popular interview questions of MS SQL DBA

Top HR questions asked in DXC Technology MS SQL DBA