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 |
|
stumbling
Posting Yak Master
104 Posts |
 Posted - 2007-02-13 : 21:25:47
|
| Hi ALL,I have something that i have been wondering about for a while now and hope someone can help clear this up for me.My mdf and ldf files on my server have a time stamp from 2 days however the database is in use 10 hours a day including backup time. Is there any reason for this the OS is XP SP2 and SQL 2000 MSDE.Hope some one can help on this TAStumblin |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-13 : 22:40:45
|
Yes. The MDF / LDF file date time is not update while the database is online.
KH |
 |
|
|
stumbling
Posting Yak Master
104 Posts |
Posted - 2007-02-13 : 22:51:43
|
| Thanks so am i correct in stating that say when the server was last restarted or for that matter sql server this would reflect the timestamp.Cheers. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-13 : 23:04:30
|
yes
KH |
|
|
|
|
|
|
Time Stamp