SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Data deleted - how to tell when (using .trn)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

joker77
Starting Member

4 Posts

Posted - 11/11/2010 :  07:15:12  Show Profile  Reply with Quote
Hi there,

We had an issue overnight when some of our data was deleted. Specific rows from specific tables.

We have backup files (.bak) from before and after, and Transaction Log Files (.trn)

How can I use these to tell when the data was deleted, and by who?
Thanks
Neal

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 11/12/2010 :  16:54:06  Show Profile  Send jen a Yahoo! Message  Reply with Quote
search on 3rd party tool, log readers
they usually have eval versions which you can try

--------------------
keeping it simple...
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 11/13/2010 :  05:15:15  Show Profile  Reply with Quote
FWIW (bit late now, but perhaps worth considering for next time) we have Triggers on all our tables (all the ones that matter) for UPDATE and DELETE that store the "before" data into an audit table (each table has a "parallel" Audit Table, same columns as main table but with additional Date/User columns).

Useful for accidents, diagnosis, fraud investigation ... etc
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 11/13/2010 :  09:10:01  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Asked and discussed at length: http://www.sqlservercentral.com/Forums/Topic1019240-357-1.aspx

--
Gail Shaw
SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000