Our database is running in full recovery mode and we backup the log
file every hour and the database file every night. I notice the
timestamp of database file *.mdf remains unchanged a few days. For
example one database has its timestamp at Apr 15 while it is Apr 20
already.
I am wondering if this is acceptable. How do I force the system to
flush the data and dirty blocks to the disk more frequently? What is
the downside to this?

Thanks for any idea.

akkha1234 (AT) gmail (DOT) com (akkha1234 (AT) gmail (DOT) com) writes:
I don't think you should pay any attention to the dates you see in
Explorer. The database files are open all the time, and data modifications
will not affect the dates. Only operations that affects the size of the
files does. That is, if the file autogrows, this will be refleced in
Explorer.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx