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 |
|
BjornOtto
Starting Member
8 Posts |
 Posted - 2010-07-22 : 13:59:59
|
| I have production databases used daily but both the database files and the log files have dates on disk that are over 10 days old. They are set for full recovery. Are they all just living in memory? All databases and logs are backed up once a day only.It seems to me that if the server was to go down, recovery would not be to actual point in time. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-22 : 14:57:21
|
I think file date/time is the later of last shutdown of SQL Server (or possibly latest startup of SQL Server) or expansion of the files (and maybe some other things like Shrink)Definitely not a safe indicator of the files being in use  I've always assumed that updating the file timestamp every time the file was (physically) written to was just way too much overhead, and disk-head-travel ... but that's just a hunch. |
 |
|
|
BjornOtto
Starting Member
8 Posts |
Posted - 2010-07-22 : 16:00:02
|
| Thanks! That's actually peace of mind... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Active log files have old dates
Tara Kizer