Home Forums SQL Server 2005 Backups Data deleted - how to tell when? (using .bak and .trn) RE: Data deleted - how to tell when? (using .bak and .trn)

  • November 11, 2010 at 5:49 am

    #1249418

    Vishal.Gajjar (11/11/2010)

    You might be able to find the approximate deletion time by applying T-Logs one by one,

    but you won't be able to find user name, unless you have Audit Trace.

    Really?

    I would have thought a 'Transaction Log File' would give you this, seeing as by definition it should hold every transaction in the database?