Is there a way to query SQL Server logs to see when DML occurred?

• smithsp17

  Mr or Mrs. 500

  Points: 515

  More actions

  August 25, 2009 at 12:34 pm

  #137532

  Hi,

  Is there any way in SQL Server 2005 to query the transaction logs to see when a user executed a DML statement? I had a user delete some data, and I would like to have restored it to just before the delete statement was executed. This would be something similar to Oracle's Log Miner.

  Thanks,

  Steve

• GSquared

  SSC Guru

  Points: 260824

  More actions

  August 25, 2009 at 12:35 pm

  #1044432

  If the database is in Full recovery mode, then yes. ApexSQL and Lumigent both publish log parsers that can read SQL 2005 transaction logs.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon