Expected transactions not appearing when reading the log file via Log Reader (4227603)

Reading in transaction log backup file(s) using Log Reader and the last few transactions do not display, the last transaction timestamp is well before the time the backup was performed.

This issue can occur if the settings are not correctly set.  Ensure you have the following settings for Log Reader:

"Reconstruct DDL command" should be ON,

"Request full database back up file if needed" should be OFF,

"Read entire log file" should be ON.

These settings can be found in Tools->Options->Log Reader.   If you had to change any of these settings, please reread the transaction log.

NOTE : Transaction logs will contain only alter (rename too), create and drop DDL statements and insert, update, delete DML statements. So if  the last transaction(s) included only select statements,  these commands will be absent from the log.