Data Files modification date

[rac2]

This is a question about the physical file which stores the database, the .mdf file in particular.

I notice that the dates Modified and Accessed shown by Windows Explorer file Properties do not match the activity in my databases. Databases which are continuously used and in which data is always changing have Modified dates several hours or even several days in the past.

Why is that?

 

[mrdenny]

The date and time stamps on the physical files are irrelevant to the load within the database. The only time you can guarantee that the date and time will be updated is when the SQL Server is shutdown.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com