469,333 Members | 4,354 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,333 developers. It's quick & easy.

timestamp ans status of database file

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.

Apr 20 '07 #1
1 2073
ak*******@gmail.com (ak*******@gmail.com) writes:
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?
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, es****@sommarskog.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
Apr 21 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Bruno Batarelo | last post: by
4 posts views Thread by Mark Harrison | last post: by
5 posts views Thread by kyosohma | last post: by
7 posts views Thread by bdbeames | last post: by
1 post views Thread by Frank Swarbrick | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.