Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

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?

Flowing Fount of Yak Knowledge

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


United Kingdom
22859 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

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:

Gail Shaw
SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next 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.04 seconds. Powered By: Snitz Forums 2000