title: SQL Server: Why isn't the log file up-to-date with the database file on full recovery mode?
body: <p>Using SQL Server 2012 on full recovery and looking at the directory:</p>
  
  <pre><code>C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\
  </code></pre>
  
  <p>I see .mdf and .ldf files.</p>
  
  <p>For a particular database, the modified times are very different? Why is this? I would have thought that as you modify a database your transaction would be recorded in the ldf file (regardless of the type of query)?</p>