Question

List the types of transaction logs that can be used in a database and it's usage.

Answer 1

Logs are the only mode through which your troubleshooting begins. From log files or the logs that are generated helps in debugging the issue. Similarly, database logs do the same thing in fixing the issue or even troubleshoot the issues. Here are the few types of logs:

• The update log records basically logs the update made to the database change. Through this particular logs it could be understood the update changes made to the DB.
• Second type of logs are the compensation logs that mainly records the rollback made to a particular change. This corresponds to the update log records.
• Commit records describes the changes committed to the DB.
• Completion records describe the completion of a particular transaction into the database.