Is it possible to read the transaction log in text/table format, and if so, how can I do that?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
The following query will output the full contents of the current log in tabular format. If you only require a portion, replace the NULLs with LSNs.
If th.e data is no longer in the log, then the following query will return the contents of your log backup.
Yes, you DO have to specify all 63 default values. These represent files and you can have up to 64 files in a backup set.
Paul Randal blogged about this topic here.
There are different ways to open an LDF file, and most of them do just that – opens it. It’s tricky to get any human readable information and make a use of it though
To be able to read transaction logs in order to see the operation type, the schema and object name of the object affected, the time when the operation was executed, the name of the user who executed the operation, and more, check out the Open LDF file and view LDF file content online article
Disclaimer: I work as a Product Support Engineer at ApexSQL