Query a Sql Server LOG (LDF) File

• salimgbelim

  Old Hand

  Points: 336

  More actions

  October 31, 2003 at 4:24 am

  #106540

  I was just wondering is there any way to query the transaction log life in sql server?

  actually i want to get what table where updated during particular time range.one way is if i take transaction log back up and query those transaction log i can get it.is there any other ways to achieve this.

  Regards

  Salim

  salim

  
  salim

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  October 31, 2003 at 4:42 am

  #480422

  http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12279 might help you

  Frank

  http://www.insidesql.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• swjohnson

  Hall of Fame

  Points: 3254

  More actions

  November 3, 2003 at 11:44 am

  #480687

  Salim,

  We use a product from Lumigent called Log Explorer that is awesome. Also I believe Lockwood Technologies has a program similar to Log Exploer but I have not used it.

  There are several undocumented commands that you can use, search around for DBCC LOG and you should be able to find the commands.

  Shawn

  

  ---

  Accepting all invites