MDF & LDF Files dates

  • Hi All,

    I need clarification with regard to Data and Log files. The dates

    for these MDFs and LDFs is not getting change by the day, though these

    databases are used round the clock by the application, the dates of the

    MDFs and LDFs does seem to change. Is that how it is supposed to be or do

    they need to change? I have checked with other server locally, the dates of

    the files seem to changing by the day.

    Please Help me

    Manoj kumar

  • Manoj,

    I assume you mean the modification date. If you look at the properties of the file, the create date will remain the same. It makes sense that the modification date would change since the databases are in use. If no updates, backups, or other accesses to the database are performed, the date will not change.

    Guarddata-

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

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