Chapter 5. Logging and recovery
Kalen Delaney
Chapter 3 covered the data files that hold information in a Microsoft SQL Server database. Every database also has at least one file that stores its transaction log. Chapter 3 referred to SQL Server transaction logs and log files but didn’t really go into detail about how a log file is different from a data file and exactly how SQL Server uses its log files. This chapter explains the structure of SQL Server log files and how they’re managed when transaction information is logged. You will learn about how SQL Server log files grow and when and how a log file can be reduced in size. Finally, you see how log files are used during SQL Server backup and restore operations and how your database’s recovery ...
Get Microsoft SQL Server 2012 Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
