Hello
I'd like to ask you what portion of data show Log Reader? For example when I use ApexSQL I see more data. Is there only active portion of log?
Thanks
Welcome to the Toad/SQL Server community!
I think you're right... ApexSQL Log is specifically designed to extract the most from your log files....that's what it does.
Toad for SQL Server, on the other hand, was designed with the idea that much of what a SQL Server professional would want is embedded in a convenient IDE (e.g. quick data access/queries, SQL tuning, code debugging, database compare & sync, test data generation, etc.) Think swiss army knife.
That said, if there's something we're not extracting from the Log files that you need to see, let the Dev folks know in this forum what those data elements are, or please land your idea for enhancement on the Idea Pond here:
If anyone is in search of the best way to view or restore corrupted or damaged SQL Transaction Server Log Files then I would suggest a utility that can allow you viewing of
lost SQL files easily.
Read More Info @ SQL Server Transaction Log Reader