Take the tour ×  I have SQL Server Database and we have many
tables. To improve performance, I have created different
filegroups with files on different disks just for indexes. I
have created new index today in a different file group. However,
I still see last modified date of file as 1 month in the past. I
have checked file names and I am worried that SQL Server is not
setting Last Modified date of file. The new index works fine,
but the file still does not show me a more recent modified date.
Ok I have just learned something new, none of the files in SQL
Server's Data directory shows last modified date to recent date
while, my database is continuously updated. All dates are 1
month old. The server's system clock is correct.  share|improve
this question What are you asking exactly? If the old dates
shown by Windows is a bug of SQL-Server or some other
software/hardware failure and you should be worried? Or how to
find the last time a database was modified by SQL-Server? Or
something else? –  ypercube Sep 11