Chapter 5. Logging and Recovery
In this chapter: |
In the previous chapter, I told you about the data files that are created to hold information in a Microsoft SQL Server database. Every database also has at least one file that stores its transaction log. I made reference to SQL Server transaction logs and log files in Chapter 4, but I did not really go into detail about how a log file is different from a data file and exactly how SQL Server uses its log files. In this chapter, I’ll tell you about the structure of SQL Server log files and how they’re managed when transaction information is logged. I’ll explain how SQL Server log files grow and when and ...
Get Inside Microsoft® SQL Server™ 2005, Fourth Edition 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.
