There is an error with the LogReader in Toad for SQL Sever v8.1, where it is not possible to read transaction log files, as the following error appears at the moment of trying to read the log file:
''Could not load file or assembly 'LogReader.SQLServer.SLS,
Version=8.9.1.310, Culture=neutral,
PublicKeyToken=c862883b2ae69822' or one of its dependencies.
An attempt was made to load a program with an incorrect format.'
The steps to replicate:
- Connect to DB
- Open Tools | Administer | LogReader
- Choose 'Online Transaction Log' click next
- Select Instance and DB, click next
- Select transaction log backup file, click next
- The error appears
WORKAROUND:
Toad for SQL Server 8.0 does not have this issue, hence using v8.0 is recommended if this feature is required.
STATUS:
Waiting for fix in a future release of Toad for SQL Server
