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 |
|
nicole
Yak Posting Veteran
97 Posts |
 Posted - 2005-11-02 : 21:27:58
|
| From Windows Explorer, the modified date of the database file is not updated. Why?I assumed the modified date of the .MDF/.LDF files will be updated when transaction is made to database. Am I correct? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-03 : 07:41:55
|
| Nope....the file date/time is not updated until the file is CLOSED....and the file won't be closed until the SQL Server engine closes it...either at system shutdown, or if/when the DB is detached |
 |
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2005-11-03 : 11:58:00
|
| I found that the modified date of the .LDF file is updated when I used the DBCC SHRINKFILE command to truncate log.... |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-03 : 12:08:35
|
| It would be a fair guess to deduce that that action would involve closing the file in some manner.... |
|
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2005-11-03 : 21:25:10
|
humm  That means it's unable to determine when the datafile is last acessed |
|
|
|
|
|
|
View from Windows Explorer