June 22, 2005 at 7:05 am
Looking for some explanation for when the file modified date gets changed for .ldf and .mdf files. Windows Explorer does not seem to provide the date I would expect. For instance when a tran log gets dumped the date modified would change.
Any information would be appreciated,
June 23, 2005 at 1:09 am
You have just found the reason that no other application should ever touch a database file except for SQL server. This feature is not unique to SQL Server, most Client Server database engines to not modify the file with normal operating system file functions, so the normal properties of a file are not changed when "saved".
This is also why the Jet database engine is problematic as it does use the OS file functions as each user actually opens the database files, so any user can corrupt the file with a loss of connection while writing to the file.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply