Timestamp SQL databases files are incorrect with Controller?


i am using Cognos controller 8.4 and i noticed that the timestamp of the mdf and ldf files are like 2 weeks old!? ???
I am sure that these are the correct database files. Is this ‘as designed’ or are my SQL databases corrupt?
Controller application is working well though…


Hi CognosGirl,

The changes in the database file timestamp occur when an alter database command alters the physical file, like an autogrow operation or a dbcc shrinkfile operation, which reduces the size of the physical database file.

Normal data modifications which do not cause the datafiles to auto grow, do not affect the file attributes at an operating system level.


YES! :slight_smile:

That’s it!