Return
-
Title
Log Reader. How to enable Log Reader to check if a transaction was rolled back? -
Description
Is it possible to use Log Reader to go back and check the transaction log backups taken by LiteSpeed to see if a transaction was rolled-back? -
Cause
Check for rolled-back transaction(s). -
Resolution
Yes, SQL Server tracks rolled back transactions just like it tracks committed ones in the transaction logs. LiteSpeed does not collect nor store any transaction information – it only reads the log data in SQL Server (or backups).
First, you need to enable the option to show them in LiteSpeed Options. To get to LiteSpeed Options, select Tools | Options and the click on the Log Reader tab. Check the box - Show uncommitted transactions.
See the attachment which illustrates where they will be visible in the Log Reader.
-
Attachments