Although it displays last modified date ,It is the last time the "data file" or "log file" has been modified physically ,not when the actual data has been modified.
If there are inserts, updates or deletes it happens with in the data or log files which may not result in physical growth of file. The files are grown (if automatic growth option is set) when database engine does not find any space inside the file to complete an Data modification operation.

regards
Elias Peter


-----Original Message-----
From: K.[Email Address Removed] [mailto:K.[Email Address Removed] October 30, 2003 11:22 PM
To: LazyDBA.com Discussion
Subject: 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 keep changing by the day.
Please Help me
Thank you very much in advance

Manoj kumar



*********************************************
This communication which may be confidential and privileged and the
views expressed herein may be personal and are not necessarily the
views of Coats plc. It is for the exclusive use of the intended
recipients(s). If you are not the intended recipient(s), please note that
any distribution, copying or use of this communication or the information
in it is strictly prohibited. If you have received this communication in
error, please notify us by email (Apps.[Email Address Removed] or telephone
our technical support helpdesk at Coats plc. +44 (0)20 8210 5100
(UK 0830h - 1800h, Mon-Fri, GMT) and then delete the e-mail and
any copies of it.
**********************************************


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page