August 21, 2002 at 12:57 pm
I have a database with MDF timestamp of 08/05/2002 11:52AM and LDF timestamp of 08/21/2002 05:35AM (as viewed through Explorer). The database is on a regular maintenance plan with full backup once per day and transaction log backup every three hours. It appears to be working fine and restores properly with transaction logs on a test server. Is this something that I should worry about?
Kerry Conner
Kerry Conner
August 21, 2002 at 3:00 pm
In short, no. Due to the way that SQL Server and NT both handle file locks, it is not uncommon for such a disparity with open files.
Brian Glass
Sr. Database Adminstrator
Bombardier Aerospace
August 21, 2002 at 3:10 pm
Don't forget you write to these files at different time, therefore, I would expect that there would be a difference.
Steve Jones
August 22, 2002 at 4:23 am
Also keep in mind that Explorer is set to show modified date on the screen, the create date is in the files properties. As a log file contains transaction info it is generally always in a state of modification where the mdf may or may not be.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply