Use the Read Log Wizard to load the transaction log into the Log Reader.
Note: To view the transaction log of an active database, such as on the Full Log page, make sure the Log Reader server components are installed on the SQL Server instance hosting the database. For more information, see Install Log Reader Server Components.
To read a transaction log
Ensure there is at least one active connection to a database, then select Tools | Administer | Log Reader. This will automatically launch the Read Log Wizard.
Click on the Log Reader toolbar.
Complete the wizard.
Log Reader reads logs from disk or the cloud.
Log Reader supports striped files.
On the Select Backup Files page, consider the following rules for specifying additional transaction log backup files to read :
If you selected Native or LiteSpeed Backup File, you must specify additional backup files in increasing sequential order from the selected full backup file. For example, select the file full_backup and the subsequent files following transaction_log_backup_1 and transaction_log_backup_2. You cannot select to read transaction_log_backup_2 only.
Log Reader can read backup files from local or Cloud storage. When Cloud storage is selected, please specify the correct Cloud account details.
With the Log Reader, you can view the following information from the transaction log:
Note: When you read the transaction log of an online, offline or detached database after the SQL Server was upgraded, the Log Reader does not process and display the transaction log entries that were created before the upgrade.