Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010
    Posts
    1

    Unanswered: Data deleted - how to tell when? (using .bak and .trn)

    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

  2. #2
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Unless you are aduting the table, there is no way to find out "who". As far as when, it's all going to depend on when you no longer find the data in the database during log restores. It'll be a best guess when, especially dependent of how frequently you back up the logs. If it's hourly, you can assume it occurred in the last hour. Nightly, then sometime that day.
    -- You can't be late until you show up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •