• The transaction log is used for all modifications to guarantee atomicity, durability and consistency. Read Gail's thorough article.

    http://www.sqlservercentral.com/articles/Administration/64582/