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?

AnswerBot
1y

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 ...read more

srinivas
3y

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

Sankala Sreenivasulu
3y

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

Select
Add answer anonymously...

DXC Technology MS SQL DBA interview questions & answers

A MS SQL DBA was asked Q. When we run CheckDB, what command does it run in the background?
A MS SQL DBA was asked Q. If TempDB is full, how do you resolve it?
A MS SQL DBA was asked Q. Do you have any experience with SQL Profiler?

Popular interview questions of MS SQL DBA

A MS SQL DBA was asked Q1. When we run CheckDB, what command does it run in the background?
A MS SQL DBA was asked Q2. If TempDB is full, how do you resolve it?
A MS SQL DBA was asked Q3. Do you have any experience with SQL Profiler?
DXC Technology MS SQL DBA Interview Questions
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+

Reviews

10L+

Interviews

4 Cr+

Salaries

1.5 Cr+

Users

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.

Follow Us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter
Profile Image
Hello, Guest
AmbitionBox Employee Choice Awards 2025
Winners announced!
awards-icon
Contribute to help millions!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos
Add office benefits
Add office benefits