Discrepancy between recent activity and transaction log file

• kaplan71

  Hall of Fame

  Points: 3634

  More actions

  July 19, 2013 at 7:06 am

  #280341

  Hello --

  I am monitoring our database server using dbWarden and ApexSQL log viewer. The dbWarden utility reported activity within the past twenty-four hours to a particular database's mdf and ldf files. I opened the latter application to investigate. When I opened ApexSQL viewer, without any filters, the last entry that was displayed was from the July 9 date. Hence there is a discrepancy of ten days between what was supposedly written last night, and what was recorded to the database.

  To add to the confusion, I checked the directory where the ldf file is located, and according to the details of the file, the last modification date was the July 3 date.

  What would cause the discrepancy that I described, and what can I do to correct it?

  Thanks.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  July 19, 2013 at 7:33 am

  #1634020

  The OS time stamps on database files are meaningless.

  Not familiar with either tool, so all I can guess is they're showing you different things.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass