O'Reilly logo

SQL Server Transaction Log Management by Tony Davis, Gail Shaw

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 7: Dealing with Excessive Log Growth

This chapter will examine the most common problems and forms of mismanagement that lead to excessive growth of the transaction log, including:

  • operating a database in FULL recovery model, without taking log backups
  • performing index maintenance
  • long-running or uncommitted transactions that prevent space in the transaction log from being reused.

Of course, if growth is left unchecked, the log file may expand until it devours all of the available disk space or the maximum size specified for the log file, at which point you'll receive the infamous 9002 (transaction log full) error, and the database will become read-only. This chapter will cover the correct ways to respond to runaway log growth 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