![Apex sql log](https://kumkoniak.com/67.jpg)
![apex sql log apex sql log](http://16533478.s21i.faiusr.com/4/ABUIABAEGAAgl8XF1wUoxuiZzgcwigU4zAQ!400x400.png)
In the Select data sources step, Add the continuous sequence of transaction log backups up to the point in time when the transactions you are looking for occurred.If database that you are auditing is in the full recovery model, then proceed with the steps below to provide necessary transaction log backups to recover/show all of the transactions you are looking for: You had used the ApexSQL Log default filter setting and inadvertently filtered out the data you were looking forĪpexSQL Log can show/recovered all transactions only for databases in the full recovery model.The database that you are auditing is in the full recovery model, you have the transaction logs that contain the transactions you want to see, but you didn’t add all transaction log backups necessary for successful transaction reading.The database that you are auditing is in the full recovery model but you didn’t add the relevant transaction log backups.In this scenario ApexSQL Log will inform you that selected database uses the Simple recovery model Only the most recent data will be displayed. The database that you are auditing is in the Simple recovery model and the transactions you want to see don’t exist in the online transaction log anymore. There are several reasons that can cause this behavior: You know that these transactions were executed, but ApexSQL Log doesn’t show them. You are using ApexSQL Log on a database where transactions are executed some time ago. This article explains why ApexSQL Log shows only some of the transactions you expect to see and how to show/recover all of them.
![Apex sql log](https://kumkoniak.com/67.jpg)