Transaction Log in Sql Server

For what statements DDL or DML, Transaction log is maintaine开发者_如何学Cd and Why?

---

The transaction log is used to record information on each of the transactions that have occurred. You can use it to be able to roll back transactions, or in the case of a database recovery operation you can restore from a backup and roll forward using the recent transaction log files to re-apply any changes that have been made to the database.

Here is a helpful article that talks about it in a bit more detail.

---

It's maintained for all DML and DDL operations, and the main purpose is to ensure the ACID properties of a database: http://en.wikipedia.org/wiki/ACID

However, auditing and recovery possibilities via the transaction log are possible too, but as an effect of its design which follows ACID