SQL Server Transaction Log Management
Download or Read eBook SQL Server Transaction Log Management PDF 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.
Author | : Tony Davis |
Publisher | : Red Gate Books |
Total Pages | : 232 |
Release | : 2012 |
ISBN-10 | : 1906434964 |
ISBN-13 | : 9781906434960 |
Rating | : 4/5 (64 Downloads) |
Book Synopsis SQL Server Transaction Log Management by : Tony Davis
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. --