O'Reilly logo

Inside Microsoft® SQL Server™ 2005, Fourth Edition by Kalen Delaney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Logging and Recovery

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required