CODEWITHSUNDEEP
sqlsql-serversql-server-2005
Vaibhav Jain
Vaibhav Jain

Reputation: 34447

Transaction Log in Sql Server

For what statements DDL or DML, Transaction log is maintained and Why?

Upvotes: 1

Views: 626

Answers (2)

Ivan Stankovic
Ivan Stankovic

Reputation: 1602

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

Upvotes: 0

Mitchel Sellers
Mitchel Sellers

Reputation: 63136

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.

Upvotes: 1

Related Questions