Timestamp Difference on MDF and LDF Files

  • I have a database with MDF timestamp of 08/05/2002 11:52AM and LDF timestamp of 08/21/2002 05:35AM (as viewed through Explorer). The database is on a regular maintenance plan with full backup once per day and transaction log backup every three hours. It appears to be working fine and restores properly with transaction logs on a test server. Is this something that I should worry about?

    Kerry Conner


    Kerry Conner

  • In short, no. Due to the way that SQL Server and NT both handle file locks, it is not uncommon for such a disparity with open files.



    Brian Glass
    Sr. Database Adminstrator
    Bombardier Aerospace

  • Don't forget you write to these files at different time, therefore, I would expect that there would be a difference.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • Also keep in mind that Explorer is set to show modified date on the screen, the create date is in the files properties. As a log file contains transaction info it is generally always in a state of modification where the mdf may or may not be.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 4 posts - 1 through 3 (of 3 total)

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