find who deleted the table in sql server

Found a table empty
None of the daily jobs have caused it

Want to find in any way, from AUDIT database anything about this table , or who deleted it, accessed it etc.

Thanks
Greens8301Asked:
Who is Participating?
 
Daniel WilsonConnect With a Mentor Commented:
3rd-party.  I think this will do it for you: http://www.red-gate.com/products/SQL_Log_Rescue/index.htm  And Red Gate is a very respected vendor.
0
 
Daniel WilsonCommented:
If you want to do this in the FUTURE, you canset up triggers to track it.

To find out in the PAST, you need a log analysis tool.  And it will work ONLY if the DB is in Full recovery mode.
0
 
Greens8301Author Commented:
It is in FULL recovery mode.
This tool, is it a built in tool or third party tool

Thanks
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Greens8301Author Commented:
I will try this tool

Since I am talking about production database.
I can copy the T-Logs to a development environment and mine the logs in Dev environament, correct ?


Thanks
0
 
Greens8301Author Commented:
SQL LOg Rescue will install only on sql server 2000. There is message that it must be manually installed on sql server 2005. Have you ever installed on 2005

Thanks

   
0
 
Daniel WilsonCommented:
I have not. When I tried it for 2000, their support was good ... I'd ask them.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.