Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2007-02-20 : 18:23:09
|
| I have a database called playDb..and log file playdb.ldf...strange thing is the date modified on playdb.ldf is keep changing even though nobody is using this DB ( and no backup )...the last date modified was 2/20/2007 8:00 am.. but nobody is using this db since 02/06/07...why does the date modified keep chaning even though there are no activities on this DB? no users login... no maintenenance plan... |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-02-21 : 04:10:54
|
| Do you have autoclose option turn on for your DB? |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-21 : 04:15:44
|
You frequently restart your SQL Server ?
KH |
|
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2007-02-21 : 12:31:33
|
| No auto close option.but auto shrink option is turn on..No, I don;t restart the server.. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-21 : 12:39:45
|
"auto shrink option is turn on"Very rare that that is a useful option to have turned on (not sure its "tickling" the file date though)Change the database to Offline and see if any user screams?  Kristen |
|
|
|
|
|
|
Date modified on log file