Download or read book SQL Server Transaction Log Management written by Tony Davis and published by Red Gate Books. This book was released on 2012 with total page 232 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides an understanding of the SQL Server transaction log, what it does and how it works, and its role in ensuring data integrity. Topics covered include: write ahead logging; how to perform transaction log backup and restore in FULL and BULK_LOGGED recovery models; managing log growth, and dealing correctly with an overgrown or full log; and optimizing log throughput and availability, and how to avoid log fragmentation. --