Saturday, February 25, 2012

.mdf and .ldf file modified date

SQL Server 2000
Looking for some explanation for when the file modified date gets changed
for .ldf and .mdf files.
Windows Explorer does not seem to be the date I would expect. For instance
when a tran log gets dumped the date modified would change.
Thanks for any information on this issue.While the files are open I don't think you'll see the file date change in
any way that's predictable or useful. When the db is closed, detached or SQL
Server shutdown then the date will be updated. Why do you care?
David Portas
SQL Server MVP
--|||Well,
I know that the dates are not updated when SQL server is shutdown and then
restarted.
Why do I care? Curiosity, or perhaps a determination to understand what is
happening.
Joe
"David Portas" wrote:

> While the files are open I don't think you'll see the file date change in
> any way that's predictable or useful. When the db is closed, detached or S
QL
> Server shutdown then the date will be updated. Why do you care?
> --
> David Portas
> SQL Server MVP
> --
>
>

No comments:

Post a Comment