September 30, 2010 at 9:42 am
I'm running SQL 2000 with simple recovery.
I am confused by the timestamps I am seeing on the log (ldf) and data (mdf) files for my databases. They are basically the data at which sql server was started.
As I understand it an sql checkpoint writes data to disk. So should I not see the timestamp of the mdf and ldf files change each time a checkpoint occurs?
I've tried a manual checkpoint, but still no timestamp change.
Thanks.
September 30, 2010 at 9:50 am
The files are being written to, but I am not sure that the file timestamp gets updated on every write. It might not occur until the file closes. SQL Server keeps the files open while the database is open.
I wouldn't worry about it. Are you trying to glean some information from the file date stamp?
September 30, 2010 at 9:56 am
No I'm not trying to get info from timestamp, I was just concerned when I noticed all files had such old timestamps. SQL server keeping the files open makes perfect sense! Thanks for the prompt response.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply