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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 mdf/ldf files timestamp not updated

Author  Topic 

cddot
Starting Member

37 Posts

Posted - 2009-03-05 : 00:11:48
I have files belonging to a database which is actively in use, but the timestamp when viewed using windows explorer has not changed. It is a about a week old, but the database is being updated all the time.

I have confirmed those are the right files by the following:

use dbname
select * from sys.database_files

Is this normal?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-03-05 : 00:24:32
Ignore the timestamp on the file. It is normal for the timestamp not to get updated even though there is activity on the associated database.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -