[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

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
0
Greens8301
Asked:
Greens8301
  • 3
  • 3
1 Solution
 
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
 
Daniel WilsonCommented:
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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now