|
Posted by akkha1234@gmail.com on 04/20/07 22:32
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.
Navigation:
[Reply to this message]
|