Post reply

Discrepancy between recent activity and transaction log file

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply