<div>
If the data is available (committed/checkpoint) &nbsp;then it comes from the datafile. Whenever checkpoint happen the committed data is flushed from the log file to data file.<br />
<br />
Mostly you will not touch the transaction log file when you search for the data.
</div>


If the data is available (committed/checkpoint)  then it comes from the datafile. Whenever checkpoint happen the committed data is flushed from the log file to data file.

Mostly you will not touch the transaction log file when you search for the data.

<div>
<div class="content wysiwyg-content">
I understand how SQL has data files and log files. Now let's say we have the recovery model set to full and transaction log backups are done every hour. People make changes to a customer record once every hour over a five hour period. Now I come along and look for data for this customer. SQL goes into the index to get the original data but then what does it do to get the msot recent version? Does it go though each transaction log file to get the final version?
</div>
</div>


I understand how SQL has data files and log files. Now let's say we have the recovery model set to full and transaction log backups are done every hour. People make changes to a customer record once every hour over a five hour period. Now I come along and look for data for this customer. SQL goes into the index to get the original data but then what does it do to get the msot recent version? Does it go though each transaction log file to get the final version?

SQL Locate data log files

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.