File format of transaction log and data files.

  • I want to examine the contents of log files and data files. How these files are structured , what is their file format and other detail.

    Any idea about API's or some resource through which we can explore the transaction log.

    Many tools like Log Explorer by Lumigent and SQL Apex etc are capable of examining the transaction logs. So i guess some API must be available to do this thing.

  • With what i know is that the third party tools decode the data which is available in hexadecimal format. Some of the utilities to view the hexadecimal data you can use is DBCC log and the openrowset function.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply